SQLServer – SQL Table to HL7 File

This topic has 4 replies, 2 voices, and was last updated 9 years, 4 months ago by Femina Jaffer.

Creator

Topic
May 29, 2015 at 9:55 pm #54702

Femina Jaffer
Participant

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
Creator

Topic

Viewing 3 reply threads

Author

Replies
- June 3, 2015 at 3:14 pm #82628
  
  Femina Jaffer
  Participant
  
  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.
- June 5, 2015 at 3:28 pm #82629
  
  Femina Jaffer
  Participant
  
  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?
- June 9, 2015 at 6:38 pm #82630
  
  Harpreet Khakh
  Participant
  
  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
- June 9, 2015 at 9:29 pm #82631
  
  Femina Jaffer
  Participant
  
  Thanks Harpreet, I did do that in the db configurator; it is checked but greyed out.
  
  Thanks,
  
  FJ
Author

Replies

Viewing 3 reply threads

The forum ‘Cloverleaf’ is closed to new topics and replies.

SQLServer – SQL Table to HL7 File

Forums

Forum Statistics