Thanks alot swades..
I will try and post here..
Search found 87 matches
- Wed Jan 27, 2010 2:44 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Email notification
- Replies: 9
- Views: 6397
- Wed Jan 27, 2010 11:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Email notification
- Replies: 9
- Views: 6397
- Wed Jan 27, 2010 10:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Email notification
- Replies: 9
- Views: 6397
Email notification
Hello,
In my requirement I need to send emails to 10 diff people with 10 diff attachments, Do I need to use 10 diff email notification stages to accomplish this? Is there a way I can minimise the no of stages being used.??
Please give your thoughts...
Thanks in advance
reddy.
In my requirement I need to send emails to 10 diff people with 10 diff attachments, Do I need to use 10 diff email notification stages to accomplish this? Is there a way I can minimise the no of stages being used.??
Please give your thoughts...
Thanks in advance
reddy.
- Tue Jan 26, 2010 3:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Writing into xl sheet
- Replies: 1
- Views: 1086
Writing into xl sheet
Hello,
I have requirement, where i need to write into an xl sheet from .ds or .txt file. how can i achieve that in parallel job.
your help is appreciated.
I have requirement, where i need to write into an xl sheet from .ds or .txt file. how can i achieve that in parallel job.
your help is appreciated.
- Fri Nov 06, 2009 8:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: stringtoTimestamp Conversion
- Replies: 3
- Views: 4690
- Wed Nov 04, 2009 10:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: stringtoTimestamp Conversion
- Replies: 3
- Views: 4690
stringtoTimestamp Conversion
Hello, I have to compare an incoming datefield with another date field, but my date_field1 have some null values in some records, i am trying to substitute 01/01/2001 12:00:12 in place of null to avoid the comparision fail (failed comparing date and null) my code is like this This is in Tx Constrain...
- Tue Nov 03, 2009 10:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: oracle direct load
- Replies: 2
- Views: 1635
oracle direct load
Hello, oracle load failed with following following error, SQL*Loader-951: Error calling once/load initialization ORA-00604: error occurred at recursive SQL level 1 ORA-00054: resource busy and acquire with NOWAIT specified no one else is using the table at the time of job run. please give me your th...
- Tue Nov 03, 2009 9:18 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: LKP_STAGE issue
- Replies: 3
- Views: 2323
LKP_STAGE issue
Hello all, i am using lookup stage in one of my jobs, i am getting this error Lkp_stg: When processing argument -ifNotFoundWhen processing action: No value supplied, but same job works fine in all other dev environments. failed in production.. please give your thoughts.. Thank yo so much in advance!!
- Sun Nov 01, 2009 10:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Appending sysdate to seq file name
- Replies: 2
- Views: 1487
Appending sysdate to seq file name
Hello,
I have to append sysdate to a reject file file name (capturing reject records) which runs everyday Seq_xxxx_11/01/2009.txt , Can i do that in parallel job.? please give your thoughts.
Thanks in advance..
I have to append sysdate to a reject file file name (capturing reject records) which runs everyday Seq_xxxx_11/01/2009.txt , Can i do that in parallel job.? please give your thoughts.
Thanks in advance..
- Thu Oct 29, 2009 7:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Transformer Constraint
- Replies: 3
- Views: 2262
Transformer Constraint
Hello, I one of our jobs we are comparing date with max of that date field from previous day data, i am using this condition in Tx Constraint. but in our source data we have some records with null values in the date field, and comparision failing because of that, I want to give some value in place o...
- Wed Oct 07, 2009 8:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Transformer Compile Error
- Replies: 18
- Views: 6233
- Mon Oct 05, 2009 8:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Cursor logic in Datastage
- Replies: 1
- Views: 1507
Cursor logic in Datastage
Hello all, I have a requirement, where i need to loop the records against single record. Table. Student Sub 1 Math 1 Eng 1 Sci 2 Math 2 Eng 3 Math 3 Eng 3 Sci 3 Dra Our output should be something like this 1- 1 1 1 0 2- 1 1 0 0 3- 1 1 1 1 1 says student has that subject 0 says he does not have. Inpu...
- Tue Sep 29, 2009 12:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: reading CLOB datatype from Oracle.
- Replies: 4
- Views: 2485
- Tue Sep 29, 2009 11:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: reading CLOB datatype from Oracle.
- Replies: 4
- Views: 2485
reading CLOB datatype from Oracle.
Hello,
We have ClOB datatype in oracle in one of our jobs , when i try to read, i am getting error, PEEK_IDENT by searching here i found DS does not support CLOB datatype, i dd not find any workaround, please kindly give your thoughts on this.
Thanks alot..
Reddy.
We have ClOB datatype in oracle in one of our jobs , when i try to read, i am getting error, PEEK_IDENT by searching here i found DS does not support CLOB datatype, i dd not find any workaround, please kindly give your thoughts on this.
Thanks alot..
Reddy.
- Sun Sep 27, 2009 9:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SQLLDR ignoring APT_ORACLE_LOAD_OPTIONS
- Replies: 11
- Views: 10242