Search found 92 matches
- Sun Aug 07, 2005 11:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Substracting Days from a Date
- Replies: 5
- Views: 2918
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...
- Wed Jul 27, 2005 4:00 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: dsjob showing status code = 1
- Replies: 16
- Views: 8911
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 ...
- Mon Jul 25, 2005 4:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null handling in PX Sequential files
- Replies: 23
- Views: 22647
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...
- Thu Jun 09, 2005 4:11 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Clearing DSEngine/dsdlockd.log
- Replies: 15
- Views: 11303
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...
- Mon Jun 06, 2005 6:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: configuration and partitioning
- Replies: 6
- Views: 2248
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...
- Mon Jun 06, 2005 5:24 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to declare & use parameter in Routines
- Replies: 14
- Views: 14343
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...
- Tue May 31, 2005 5:37 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: # Problem In Table Name
- Replies: 5
- Views: 1397
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
- Tue May 31, 2005 5:14 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Parse Header, Trailer and Detail using CFF
- Replies: 6
- Views: 3105
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...
- Tue May 31, 2005 5:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: compilation error - Error when checking composite operator
- Replies: 6
- Views: 4654
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 ...
- Mon May 30, 2005 4:03 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: file merge
- Replies: 12
- Views: 4626
- Wed May 25, 2005 6:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Passing parameteres through Unix Script
- Replies: 4
- Views: 2959
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...
- Wed May 25, 2005 6:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: blank rows in the file
- Replies: 6
- Views: 2122
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...
- Wed May 25, 2005 5:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Ascential Certification
- Replies: 9
- Views: 4950
Ascential Certification
Hi All,
Please share information whethere Ascential has any Certification program on DataStage PX and eligibility criteria and fee, etc.
Please share information whethere Ascential has any Certification program on DataStage PX and eligibility criteria and fee, etc.
- Wed May 25, 2005 5:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ORACLE Open Command
- Replies: 15
- Views: 8364
- Wed May 25, 2005 5:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: row to column
- Replies: 4
- Views: 2165