SQLServer – SQL Table to HL7 File

[Femina Jaffer]

Friends,

I am having a lot of trouble with this today.  I have a jdbc connection already to a sql server and database.  I have created the schema via database configurator.  All I need to do is read data from a sql server (inbound) thread and write the output to a file and using and xlate (input database schema) output ORU_R01 HL7.

I am not able to get the data to write out to a file using the translation.  I do get a java core heap file after a few minutes.

Thanks,

Femina

Topic

[Femina Jaffer]

Okay, I got this working when I write a query for the top 10; but when it writes out the entire contents of the query, it errors out.

[Femina Jaffer]

I have added a query in the READ SUCCESS tab to set a flag at a column.  I am hoping that will do the trick.  It does for a smaller file.

Anyway, I have another problem and would really be most grateful if someone can shed some light.  This one I have been struggling with for quite some time.  Anyway, I am just doing a select on one column in my  query, yet the out put file is placing commas before each segment. For example, here is the output:

,,,,,MSH|^~&|Sunquest|TriCore|X|X|20150602151840||ORU^R01|20150602000001|T|2.3|||AL,

,,,,,PID|||||SCOTT^LARAINE^||19431025|F||||YIJ804001800|||||000000230510|585075960,

Any idea why this is happening?  Could this have anything to do with encoding?

[Harpreet Khakh]

Hi Femina,

In database configuration scenario, columns are returned based on table mapping, if select returns only one column, all others will be blank.

If you really want only one column returned, disable (uncheck) all other columns in database configuration.

Hope that helps.

Thanks,

Harpreet

[Femina Jaffer]

Thanks Harpreet,  I did do that in the db configurator; it is checked but greyed out.

Thanks,

FJ

[Author]

Replies