DSXchange

Hi, My job extracting the data from table and loading into target table. while loading the data , there are few columns need to be loaded in JSON format. Here is the scenario. Input: FIRST_NAME LAST_NAME Output: FULL_NAME "fullName":{ "firstName":"ROSE", "lastName&...

Hi all,

while executing the job in datastage 8.7 .while loading the data into DB2the below errors are coming


Error 9 occurred while closing the named pipe.
The DB2 Load API call failed with SQLCODE -668.
Error 88 occurred while writing to the name

Looking forward for your help

Thanks
Srini..

HI, I am using DS 8.7 Parallel version. I have a requirement like this. my source is, FirstName|Middlename|Lastname john james|david|mcallister john james|john|mcallister james I want out put like below. FirstName|Middlename|Lastname John James|David|Mcallister John James|John|Mcallister James Start...

Yes...The issue is only for CHAR fields.

Hi,

In Datastage 8.7 , we are seeing 0x0 getting inserted in target database (Oracle) instead of null . we should have null value inserted if incoming data for a particular filed is empty.

please advise me on this issue.

Thanks
Srinivas

Thanks alot chandra. It works fine.

Hi, I am working on IIS 8.7 SRC : Seq file stage target: Oracle connector Source file is having the fields CRET_DT : 08-MAR-13 and MOD_DT :15-MAR-13. I am using StringToDate(DSLink4.CRE_DTTM,"%dd-%mon-%yy").but its giving following error. Transformer_7,0: Data string '08-MAR-13' does not m...