DSXchange

Hi In PX in a parallel transformer you can use DateFromDaysSince function to achieve the same. If (CcartAcd330_Lookup_Exception.Level_1_Id = 1 Or CcartAcd330_Lookup_Exception.Level_1_Id = 2 Or CcartAcd330_Lookup_Exception.Level_1_Id = 3) and CcartAcd330_Lookup_Exception.DATERAPPORT >= DateFromDaysSi...

Hi, Return code $? will return 0 if the command dsjob is successful and would return non zero when it fails. You do not get the status of job. For this once you run the command. You can run the dsjob -jobinfo and check the job status. this would give you the job status exactly. you can try this run ...

Hi, Roy's test worked fine because the data type he used was varchar. When a varchar field is read from a Sequential file the same record as below. 6595960093|||||text is interpreted differently. col2, col3,col4, col5 and col6 re varchar fields in this case. this record will be read in any case. But...

Hi Kim, if this file dsdlockd.log goes beyongd 2GB I hope it does not allow writing into this file. This is the case with some of Unix machines. On some machines max file size is 2GB. I never came across such a situation but, can you tell if this file is really 2GB size and what are the consequences...

Hi Shankar, What is 2*2 is it 2-node configuration file you are referring to ? Any way I see you are hash partitioning on acctid and custid. Are you any chance sorting and using unique option ? This could be one reason for loosing the records. When you use default partitioning perform sort with uniq...

Hi Devyani, Can you be more specific about your requirement, do you have a file which has parameter and values. These parameter s and values are used in job and in the sme job you have a routine which reads this file to access the parameters and values. In case you need to access the parameters from...

Hi snassimr, In DataStage if you use # DS interprets it as start of Job parameter. When you have a query with job parameters bieng used you use SELECT * FROM #SCHEMA#.#TABLE_NAME# where SCHEMA and TABLE_NAME are job parameters. to parse # as literal use back slash as escape character and try. Regards

Hi rhettbutlernc, If you are not really interested in Header and trailer record then just give schema of Detail record. All teh records which do not match this schema would be just rejected with out bothering you. I you want to capture these Header and Trailer records add a reject link to the Sequen...

Hi Please chak your compiler option from the above log it looks like a compiler issue at first look. ##W TBLD 000000 12:23:08(006) <main_program> Error when checking composite operator: Output from subprocess: his file includes at least one deprecated or antiquated header. Please consider using one ...

Hi,
Here the topic is about appending a file to another and not merging of files based on akey.
So the job design would be like read from both the files and collect the data and write to a file.

Hi Madhav, This is very much possible if you see teh command dsjob you have an option -param wher you specify the parameter value. so if you can build the command like dsjob -run <server> <project> -param <value> -param <value> .... This can be achieved through Unix script. Once you build the comman...

Hi madhur, Can you be clear whether your balnk line means something like this XXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXAAA or XXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXAAA In first case no need to wory as these records will be rejected by the sequential file stage if you want these records to be trapped then use a...

Hi All,
Please share information whethere Ascential has any Certification program on DataStage PX and eligibility criteria and fee, etc.

hi JSWARBRI,

Try to execute the command
'DELETE FROM DBADSSDEV .T1_NDS_OFF_LINKS'

as it is and see if it executes.
If it is fine then ok.

Hi Vivek
Pivot will do the work this should be there in Parallel Canvas.
You'll find it in in Designer if you right click you'll get Customimze pallette from there you just choose the satge from parallel option.