DSXchange

Our database need to be migrated from DB2 to oracle . During migration, we met some waring message for int(32)/int(64) conversion (almost everybody had met it during conversion :D ) My understand is : In DB2 , Smallint is -32 768 to 32 767 (5 digits) Integer is -2 147 483 648 to +2 147 483 647 (10 d...

Hi Devi,

Did you get your problem resolved?

Regards,
A DS Developer

Hi there, The simple test job contains a CFF as source, a transformer that does direct mapping and finally a target sequential file. Our source data is cyrillic (codepage = ibm 1025) and it resides in Mainframe. External to DS, we transport the data from MF to AIX P-series in binary EBCDIC format in...

Thanks for the tips, Ray!

Phew.. I had the right guess. It was all because of different Group membership of the two DS/Unix users. I got it resolved with the help of SysAdmin. :D

Just noticed... The user who created djp_EMPLY job is a member of different Unix group than the creator of the sequence job. Both do not share any common user group except "dstage", which I suppose is not the primary group for any of these users. My guess... The failure is due to not havin...

Yes, the status of the job is "Compiled"

Hi All, I have a multiple-instance parallel job, which runs successfully when I directly kick off the job. But when I try executing it from a sequence, it throws following error messages: dsq_INTERFACE_TO_MART..JobControl (@djp_EMPLY): Controller problem: Error calling DSRunJob(djp_EMPLY.TH), code=-...

Thanks Craig, it worked!!! :D

Unable to paste picture.. Tried the following approach, but in vain :( save printscreen as jpg file in MS paint. then follow these steps.. 1. go to http://imageshack.us/ 2. click on browse ( on the right uppermiddle portion of page) .....get the file you just saved. 3. click on hostit (on the lower ...

Ray,

I check it again, and couldn't find any discrepancy in defining columns. Attaching the screenshots if you/others might notice any metadata mismatch.


http://img87.imageshack.us/img87/2863/d ... yg2.th.png

Thanks!
- NJ

Ray,

The number and type of columns in table definition precisely match with the number and type fo columns in the column list in INSERT statement!

Is NEXTVAL FOR #$prmTGT_SCHEMA#.TEST_SKSEQ a valid INSERT value from DS perspective?

Hi, Need to achieve the following thru DS job: INSERT INTO TEST (IDEN_KEY, CDE, ID) values ('456', 'XYZ', NEXTVAL FOR TEST_SKSEQ) TEST is target table in DB2, TEST_SKSEQ is a sequence object, Values for IDEN_KEY and CDE are coming from a source, while ID column needs to be populated from NEXTVAL val...

Hello, Sorry to hijack the thread, but I'm also facing the same problem and the workaround given by mszablew is not working for my project. DB2 (and in turn DS) is still throwing the warnings :?: Would appreciate if anybody can help me out. Let me know you need more details. Thanks in advance! - NJ

Hi, Even I'm getting the same error while trying to execute (ExecSH) a script from Before-job subroutine. Waring msg : djp_CDE_INTERFACE_MI..BeforeJob (ExecSH): Error when executing command: sh /data/ds/dpr_smi_dev/scripts/truncate.sh usr_val xyz abc bkh cde_interface_mi /data/ds/dpr_smi_dev/scripts...