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
... View more