Search found 86 matches
- Fri Aug 13, 2010 3:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: getting error when compiling the Datastage job
- Replies: 12
- Views: 40018
Are you using TRANSFOREMER in the job?? Compiler path may not be properly defined.To verify this, create a job without transformer and test it. If it compiles, fix the c++ compiler issue Thanks for your reply. i Have tested,without transformer its working fine.I am facing this problem with transfor...
- Fri Aug 13, 2010 12:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: getting error when compiling the Datastage job
- Replies: 12
- Views: 40018
getting error when compiling the Datastage job
Hi , I am getting below error when compiling the Datastage job. Can anyone help me to sortout the issue.below is the error for your reference. Thanks in advance Output from transformer compilation follows: ##I IIS-DSEE-TFCN-00001 00:24:28(000) <main_program> IBM WebSphere DataStage Enterprise Editio...
- Thu Jul 15, 2010 3:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Records are getting rejected
- Replies: 5
- Views: 1869
Add a peek output stage in addition to your Oracle stage. Identify a row that isn't working correctly, and see what the contents are in the Peek stage. Is the string too large? Nulls in other columns? Key constraints in the Database? Thanks for your reply. doc_notes column datatype in database is v...
- Wed Jul 14, 2010 11:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Records are getting rejected
- Replies: 5
- Views: 1869
Re: Rejecords are getting rejected
If (IsNull(lk_trim_trans.doc_notes)) Then TrimLeadingTrailing(lk_trim_trans.doc_notes) Else TrimLeadingTrailin(lk_trim_trans.doc_notes) What you are doing here is trying to Trim the NULL which is not possible. Your transform logic should be If (IsNull(lk_trim_trans.doc_notes)) Then SetNull() Else T...
- Wed Jul 14, 2010 9:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Records are getting rejected
- Replies: 5
- Views: 1869
Records are getting rejected
hi, my job design is 2 datasets------>join--------->Transformer---------->oracle totally ihave 29 columns to insert.if i used 28 columns its going fine,whenever i used that 29th column then records are getting rejected.its nullable column. so i hard coded that column with value which is coming from ...
- Sun Jun 27, 2010 9:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: can we use mail and html or URL as a source in Datastage
- Replies: 5
- Views: 2016
I'll readily agree with our most active participants. Those sources do not have standard connection stages because they do not have a fixed format that is easy to handle within DataStage. Rather than building custom components within DataStage for performing the processing from those sources, I wou...
- Fri Jun 25, 2010 5:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: can we use mail and html or URL as a source in Datastage
- Replies: 5
- Views: 2016
can we use mail and html or URL as a source in Datastage
hi,
can we use mail and html or URL as a source in Datastage.If possible please tell me how to acheive this.
Thanks in advance.
can we use mail and html or URL as a source in Datastage.If possible please tell me how to acheive this.
Thanks in advance.
- Wed May 19, 2010 6:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: i want to increase the varchar value
- Replies: 9
- Views: 3102
- Wed May 19, 2010 6:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: i want to increase the varchar value
- Replies: 9
- Views: 3102
- Wed May 19, 2010 5:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: i want to increase the varchar value
- Replies: 9
- Views: 3102
I am not asking about the datatype but I am asking about type of value stored in that column. If you want to do as you mentioned in first post you should first check these things 'FFFFE' is just a prefix or its a hexadecimal value. will the last 10 values always be digits? Thank you actul requireme...
- Wed May 19, 2010 4:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: i want to increase the varchar value
- Replies: 9
- Views: 3102
- Wed May 19, 2010 3:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: i want to increase the varchar value
- Replies: 9
- Views: 3102
i want to increase the varchar value
Hi,
Input value is: FFFFE8627324488
i want output as
FFFFE8627324489
FFFFE8627324490
FFFFE8627324491
FFFFE8627324492
so anyone please suggest me how to do this in datastage.
Thanks in advance.
Input value is: FFFFE8627324488
i want output as
FFFFE8627324489
FFFFE8627324490
FFFFE8627324491
FFFFE8627324492
so anyone please suggest me how to do this in datastage.
Thanks in advance.
- Mon May 17, 2010 5:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: find file size greater than 1 GB
- Replies: 3
- Views: 1629
- Mon May 17, 2010 2:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: find file size greater than 1 GB
- Replies: 3
- Views: 1629
find file size greater than 1 GB
Hi,
i want to find file size greater than 0 kb
if the file size is greater than 0kb then only i want to send that file as an attachment.
my server is in windows environment.
please help me on this.
Thanks in advance.
i want to find file size greater than 0 kb
if the file size is greater than 0kb then only i want to send that file as an attachment.
my server is in windows environment.
please help me on this.
Thanks in advance.
- Sat May 15, 2010 1:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: i have one question on configuration
- Replies: 6
- Views: 2768