Search found 52 matches
- Sat Jul 09, 2011 9:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Concatenating multiple lines into one line using loop
- Replies: 2
- Views: 1890
We tried with CurrPk=PrevPk in the loop condition and defining the PrevPK and CurrPk as stage variables and then defining a Loop Variable LoopVar to concatenate each recored with the previous concatenated value that is stored in the LoopVar. But, the loop is executed infinite times. Same thing is wo...
- Fri Jul 08, 2011 12:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Concatenating multiple lines into one line using loop
- Replies: 2
- Views: 1890
Concatenating multiple lines into one line using loop
Hi All, Below is the scenario which we are trying to do using loop in 8.5 version. The functionality is achieved already using stage variables. We are looking for doing this in loop if possible. Input File PrimaryKey Data1 Pkey Data2 Pkey Data3 Pkey1 Data1 Pkey1 Data2 Pkey1 Data3 Output we want like...
- Wed Apr 07, 2010 12:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Location of actual data in datasets
- Replies: 8
- Views: 3766
Premium membership will allow you to view the entire contents, and receive other benefits too. Meanwhile, spend some time investigating what the Data Set Management tool can show you about segment files. I did check in the dataset management and the segment file paths. The data is stored in segment...
- Sat Apr 03, 2010 3:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Number of processes in a datastage job
- Replies: 1
- Views: 2082
Number of processes in a datastage job
Hi, Below is the job design of a datastage job: Dataset-> Transformer-> Dataset With a 2 node config file will this job always create 6 processes or different number of processes. With APT_DUMP_SCORE can I see the exact number of processes in the log for this job. For what purpose APT_DUMP_SCORE can...
- Sat Apr 03, 2010 3:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Location of actual data in datasets
- Replies: 8
- Views: 3766
Re: Location of actual data in datasets
In Dataset Management while copying a dataset without giving any explicit path which location the dataset gets created. Also .ds is the descriptor file. Where is the actual location of ... I could not view the response. I am assuming that the resource disk path written inside the config file for ea...
- Sat Apr 03, 2010 3:15 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Conditional lookup in Lookup stage
- Replies: 5
- Views: 2704
- Fri Apr 02, 2010 11:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Conditional lookup in Lookup stage
- Replies: 5
- Views: 2704
- Thu Apr 01, 2010 2:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Conditional lookup in Lookup stage
- Replies: 5
- Views: 2704
Conditional lookup in Lookup stage
While doing conditional lookup sometimes after right click the input columns show disabled. When the lookup stage id replaced with a new lookup stage it enables the input columns. Is there any reason why sometimes it shows as disabled and sometimes enables.
Regards,
Suman
Regards,
Suman
- Thu Apr 01, 2010 2:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Location of actual data in datasets
- Replies: 8
- Views: 3766
Location of actual data in datasets
In Dataset Management while copying a dataset without giving any explicit path which location the dataset gets created. Also .ds is the descriptor file. Where is the actual location of the records in the dataset. Is it a single path or multiple path in the disk.
Regards,
Suman
Regards,
Suman
- Thu Aug 14, 2008 1:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job running without finishing for more than 24hrs
- Replies: 1
- Views: 1085
The job is stuck in a filter stage inside the job and it is not doing anything after that. Filter stage is supposed to split the data into four different output links based on some condition. Is there any problem with Filte stage which is causing the job to hang. This job ran earlier with the same d...
- Wed Aug 13, 2008 2:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job running without finishing for more than 24hrs
- Replies: 1
- Views: 1085
Job running without finishing for more than 24hrs
Hi, We have a parallel job with many join stages and filter stage to split records based on some criteria. The job is running for more than 24 hrs without stopping. After the filter stage the job in designner is showing 0 records and in the Monitor in director it is showing running even after 24 hrs...
- Wed Feb 06, 2008 3:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Warning about converting Nullable source to Non Nullable
- Replies: 3
- Views: 1893
Re: Warning about converting Nullable source to Non Nullable
Is the key nullable in source file.If it is then change it to nullable in the table as well. This warning will go.
- Wed Feb 06, 2008 3:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: handling null data in change capture stage
- Replies: 3
- Views: 3974
Re: handling null data in change capture stage
Hi, I have a job where i am comparing an oracle table and a sequential file. I have a key column and 2 columns (change values) for which the change needs to be detected. I updated the table with the records in sequential file. So, i deally when i run the job for the second time, all the records sho...
- Tue Feb 05, 2008 6:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Received SIGPIPE signal caused by closing of the socket
- Replies: 10
- Views: 36145
- Tue Feb 05, 2008 2:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Received SIGPIPE signal caused by closing of the socket
- Replies: 10
- Views: 36145