DSXchange

SYSDA = UNIT, other possible value is TEMP. UNIT parameter basically tells where exactly on a volume you are storing your data set and when you specify UNIT =SYSDA it means you are storing on permanent storage there. When you specify UNIT = TEMP, it means its a temporary storage on your volume where...

I am working on MVS 8x since one year on a data migration project.
How can you assist you?

easiest logic when you are comapring columns, Creat Two stage variable SVPrev SVcur assigned SVcur to SVprev and now,in SVcur concat all the coulmns which you want to compare then set Svflag= if SVPrev<>SVcur then T else F in this way you will be able to compare all the columns at a time. then on fl...

ok so its easy to switch in to server eddition.
And how does parellel job differ...can we develope Parellel jobs on windows enviourment assuming it happen only in unix Os?
What other concept need to adpated in case of switch to PX?

Hi all, I have experince working in data migration project in MVS edition with 8x version, what additional i need to learn so that i can work for PX and server version? in other way how PX and server jobs are different from Mainfrmae jobs(MVS)? Many many Thanks in Advanace. Kind Regards, Devesh singh

Function used in transformer ---> StringToTimestamp(XMLInput_db_tgt_ln.EVENTTIME [1,10] : ' ' : XMLInput_db_tgt_ln.EVENTTIME [12,8] : '.': XMLInput_db_tgt_ln.EVENTTIME[14,6],"%yyyy-%mm-%dd %hh:%nn:%ss.6") This funtion i have used .but i am not getting the actual output.My output is 2008-06...

ArndW wrote:I am not sure what is happening in your case, I just wrote a simple test (row generator -> external command -> peek) and put in your cut command and it worked like a charm. ...

I wanted to know how to use external filter stage properties so that it will recognize argument which i am sending.

Hi, I want to use Cut command in Datastage job with External filter stage. My command is Cut -d ',' -f 2 but not able to use argument part of above command in External filter stage. when I am running Datastage job getting following: External_Filter_0,0: Wrapped Unix command 'cut -d ','-f 2' terminat...