Ray, thanks for your thoughts. So, SV(b) is Status='A', but what do you mean by SV(a) ' In a new group'. Also, would LastRowInGroup() function be in one of the stage variables?
Thanks again.
Search found 144 matches
- Mon Feb 08, 2016 10:17 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Compare previous rows and with another column
- Replies: 4
- Views: 3098
- Mon Feb 08, 2016 3:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Compare previous rows and with another column
- Replies: 4
- Views: 3098
Compare previous rows and with another column
All, Have a question on an issue I am encountering now. Have two columns , ID and Status as below. ID Status 1 | A 1 | A 1 | R 2 | R 3 | A 3 | R 3 | R 3 | R Now, I want to compare with previous row and the status column. So, for ID 1, as there is one R(Rejected) but another 2 are Accepted , ID 1 is ...
- Mon Feb 08, 2016 2:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: FTP Enterprise stage
- Replies: 3
- Views: 2758
- Mon Feb 01, 2016 3:13 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: FTP Enterprise stage
- Replies: 3
- Views: 2758
FTP Enterprise stage
Hi all, We have a job which reads a .txt file through FTP enterprise stage and bulk load the data to DB2. Issue is , the job is copying the file which it reads through FTP stage and the file is stored in parallel resource folder in DS server. Job design- FTP Stage-- Transformer---Bulk Load to DB2 An...
- Wed Dec 23, 2015 8:37 am
- Forum: General
- Topic: Email notification on Abort Sequencer
- Replies: 2
- Views: 3210
- Tue Dec 22, 2015 9:56 am
- Forum: General
- Topic: Email notification on Abort Sequencer
- Replies: 2
- Views: 3210
Email notification on Abort Sequencer
Hi all, Have a question on email notification on abort sequencer. We have a sequence which has almost 15 jobs. Used an exception handler and notification activity stage which will send the email notification if any of the jobs abort. Issue is, we need to send the email to certain team if JOB 5 gets ...
- Tue Dec 01, 2015 2:42 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Substring of unknown length
- Replies: 2
- Views: 2245
- Tue Dec 01, 2015 1:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Substring of unknown length
- Replies: 2
- Views: 2245
Substring of unknown length
Hi all, Need a help in Substring of a value. We have a column ID:- 1111111111AB01, 2222222222ABCD02, 2121212121ADBC01. So its a 10 digits length of ID then character. I have (11,4) in transformer to get the character such as AB,ABCD,ADBC. Now issue is, ID length may change, it could be 11 digit or c...
- Wed Nov 11, 2015 8:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Backup File options
- Replies: 2
- Views: 2323
- Mon Nov 09, 2015 8:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Backup File options
- Replies: 2
- Views: 2323
Backup File options
All, one more question. We load a text file into DB2 tables everyday and currently Job control has the code to backup the input file in a specific folder once load is done. Now we don't want the backup file everyday instead there is a code column which has code like 'ABCDEF'. When this code is exist...
- Mon Nov 09, 2015 8:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to avoid backup pending tablespaces
- Replies: 3
- Views: 4143
- Fri Nov 06, 2015 12:59 pm
- Forum: General
- Topic: Sequencer design
- Replies: 5
- Views: 3537
- Fri Nov 06, 2015 10:23 am
- Forum: General
- Topic: Sequencer design
- Replies: 5
- Views: 3537
Thanks a lot. But kind of stuck here. So, we have , JOB ACTIVTTY1--EXECOMMAND---Nester Condition--JobActivity2 In Execute command we have the batch script and output is 12000 (count)--Trigger is Ok conditional. Then in Nested condition, Custom(Conditional)-Trim(Execute_Command_1.$CommandOutput)>1000...
- Thu Nov 05, 2015 1:35 pm
- Forum: General
- Topic: Sequencer design
- Replies: 5
- Views: 3537
Sequencer design
All, Need a help in sequencer design. I have a sequencer, Job Activity----Execute Command---Wait For File Activity-- Job Activity2 Basically, when after Job1 is completed there is a batch file which count the rows through execute command. If rows >100 then the batch file creates a blank.txt file- af...
- Wed Oct 21, 2015 1:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Seconds to HH:MM:SS
- Replies: 3
- Views: 3238