DSXchange

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.

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 ...

Ok. Thanks. I even have no heard about the issue. So far we have a windows script to delete the file from that folder. Lets see.

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...

Thank you so much Ray. Will try.

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 ...

Perfect. Thanks a lot Craig.

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...

Got it Craig. Thanks a lot.

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...

If you are using DB2 connector specifically, when you select Bulk load, there is a an option NON-RECOVERABLE LOAD- make sure its YES. It can solve the problem if proper tablespace is present in the database.

Worked. Thanks all a lot.

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...

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...

Thanks a lot. I was checking parallel dev guide.Seems like missed that part. Thanks again.