DATA Step, Macro, Functions and more

Read Data from DB2 table - Handle String with Double Quotes

Reply
Occasional Contributor
Posts: 5

Read Data from DB2 table - Handle String with Double Quotes

[ Edited ]

Currently, we are reading DB2 table using korn shell that create a txt file(Ç as delimiter) which later bring into SAS and its working fine.

We have a requirment get rid of korn shell script and directly read data from db2 using sas script. When I am reading data from db2 table using sql pass thru one of the column is getting truncated (please look for value 00011111111 in below string. Need assistance to sove this issue.

 

20150901Ç0Ç0Ç0Ç0Ç0Ç0Ç0ÇÇ"00011111111"Ç20140709Ç5500.000000000012Ç0Ç0

 

Thanks,

Dinesh

Super User
Posts: 5,429

Re: Read Data from DB2 table - Handle String with Double Qoutes

Posted in reply to neverstoplearning

What (exactly) is the data type in DB2?

Share your SQL to extract that columns and move it to SAS.

How is it truncated?

Data never sleeps
Occasional Contributor
Posts: 5

Re: Read Data from DB2 table - Handle String with Double Qoutes

[ Edited ]

data type in DB2 is defined as

 

Column name                   Data type name      Length     Scale Nulls

--------------------------------------------------       -----------       ------

ACCT_REF_NB                   CHARACTER               11          0 No

 

 

Also, looks like there a problem with buffer(readbuff). The same record is written twice after approx 100 observations.

 

Thanks,

Dinesh

Super User
Posts: 5,429

Re: Read Data from DB2 table - Handle String with Double Qoutes

Posted in reply to neverstoplearning

You are still not sharing your SQL, or given any description about the truncation.

And by adding more "problems" to the same thread doesn't really help, especially if you don't describe that either.

Data never sleeps
Ask a Question
Discussion stats
  • 3 replies
  • 219 views
  • 0 likes
  • 2 in conversation