Search found 12 matches
- Tue Jul 27, 2010 12:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: problem in reading decimal columns through CFF stage
- Replies: 2
- Views: 2201
problem in reading decimal columns through CFF stage
Hi All, I am using DS 8.1 version. I am facing some problem when I am trying to read multiple record formats by CFF stage. I have got 1 huge copybook through which I am able to import the metadata successfully. All records are fixed width having length of 1000 bytes. I have separated these records i...
- Wed Mar 19, 2008 8:16 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Manual abort of a job
- Replies: 3
- Views: 4252
Manual abort of a job
Hi,
I am trying to abort the job on the basis of 1 condition. If that condition is not satisfied, the job should get aborted.
EX: If 'SQLcode' column value is not equal to 0 then job should get aborted.
Can anyone suggest the solution for this??
I am trying to abort the job on the basis of 1 condition. If that condition is not satisfied, the job should get aborted.
EX: If 'SQLcode' column value is not equal to 0 then job should get aborted.
Can anyone suggest the solution for this??
- Tue Feb 19, 2008 8:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null handling using Modify stage
- Replies: 1
- Views: 2073
Null handling using Modify stage
Hi
I want to do null handling using Modify stage rather than transformer stage.I am using following function.
DEF= Handle_Null (DEF,'AAAA')
DEF is the column name.
But rather than transferring null as AAAA, it is transferring null only.
Can you please give me some solution?
I want to do null handling using Modify stage rather than transformer stage.I am using following function.
DEF= Handle_Null (DEF,'AAAA')
DEF is the column name.
But rather than transferring null as AAAA, it is transferring null only.
Can you please give me some solution?
- Tue Feb 19, 2008 8:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: converting the null
- Replies: 5
- Views: 2853
Hi I am also facing same problem. I want to do null handling using Modify stage rather than transformer stage.I am using following function. DEF= Handle_Null (DEF,'AAAA') DEF is the column name. But rather than transferring null as AAAA, it is transferring null only. Can you please give me some solu...
- Tue Feb 19, 2008 8:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: converting the null
- Replies: 5
- Views: 2853
Hi I am also facing same problem. I want to do null handling using Modify stage rather than transformer stage.I am using following function. DEF= Handle_Null (DEF,'AAAA') DEF is the column name. But rather than transferring null as AAAA, it is transferring null only. Can you please give me some solu...
- Mon Dec 31, 2007 7:19 am
- Forum: General
- Topic: Row to column conversion
- Replies: 1
- Views: 1679
Row to column conversion
Hi all, I am facing a problem in which I have data in a sequential file in 5 rows. In that I want all the 1st rows' data to come as column names. Can anybody tell me how to convert rows into columns. DATA IS AS: Name value column1 10 column2 20 column3 30 column4 40 column5 50 And I want the data as...
- Thu Dec 13, 2007 8:47 pm
- Forum: General
- Topic: SCD stage implementation samples in DS 8.0(Hawk)
- Replies: 5
- Views: 2718
Not sure I understand you. Are you trying to expire a dimension row? You would need to close out the existing dimension row setting end date to current date. You then need to decide whether to leav ... Hello, I have done the same thing. Iam trying to expire a dimension row with the current date. Bu...
- Wed Dec 12, 2007 3:51 am
- Forum: General
- Topic: SCD stage implementation samples in DS 8.0(Hawk)
- Replies: 5
- Views: 2718
There is a presentation on the SCD stage at the LeverageInformation site. The link is in my blog post [url=http://blogs.ittoolbox.com/bi/websphere/archives/7-even-better-online-datastage-tutorials-20 ... Hello, I used all the steps given in that presentation about SCD. But rather than updating a ro...
- Mon Dec 10, 2007 8:53 pm
- Forum: General
- Topic: SCD stage implementation samples in DS 8.0(Hawk)
- Replies: 5
- Views: 2718
- Mon Dec 10, 2007 3:37 am
- Forum: General
- Topic: SCD stage implementation samples in DS 8.0(Hawk)
- Replies: 5
- Views: 2718
SCD stage implementation samples in DS 8.0(Hawk)
Hi, Currently i am working on SCD stage in DS 8.0. But I am facing the problems of setting the purpose codes. I want to implement the Type 2 SCD. The purpose code 'Expiration date' can have the Expires derivation but I am not getting the correct method to specify it. Has anyone implemented this befo...
- Wed Nov 14, 2007 5:38 am
- Forum:
- Topic: Usage analysis in DS 8.0
- Replies: 5
- Views: 2305
- Wed Nov 14, 2007 5:11 am
- Forum:
- Topic: Usage analysis in DS 8.0
- Replies: 5
- Views: 2305
Usage analysis in DS 8.0
How would I find DS job names from the table name in DS 8.0?
It is possible in DS 7.5.1 using usage analysis..
It is possible in DS 7.5.1 using usage analysis..