Search found 87 matches

by mekrreddy
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

Thanks alot swades..
I will try and post here..
by mekrreddy
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

Thanks for your responses,

Can you guys please eloberate how I can dynamically say Email1 should get attch1 and email2 should get attcht2, so on..
Email1 - attch1
email2 - attch2
....


Thanks for your help.
by mekrreddy
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.
by mekrreddy
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.
by mekrreddy
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

I dont see validate expression when i right click, can anyone give me the syntax for this please!!!
by mekrreddy
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...
by mekrreddy
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...
by mekrreddy
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!!
by mekrreddy
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..
by mekrreddy
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...
by mekrreddy
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

Hello,

Can you try by removing(-W/Zc:wchar_t-) this from both Compiler options and linker options...
I am sure i did this when i was installing..
by mekrreddy
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...
by mekrreddy
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

Can we achieve this in SERVER job? somehow??
by mekrreddy
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.
by mekrreddy
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

Can you set errors = 1 and test with one record on source.