DSXchange

Hi All, Have a quick question. I need to run two scripts in After job subroutine from Job control. Once the job is done, first script sends the file to another server and second script should delete the original source file in FTP server. I have both the scripts. But can I use those in after job sub...

It worked at last. Probably I was missing/adding DOTs.

Thanks everyone.

Appreciate your help as always.

Sorry for the work "asking", it is not appropriate for sure.

Yes, my input data is string.

Ok ArndW. My renewal is in process,so cant see the whole explanation. From the part of it, seems like, Use, ICONV(IN.Column1.'MTS' code for each column and then add those columns as stage variable and linkup to a total time column. But when using ICONV(IN. ---- it is asking for concatinate,substring...

Okay. understood the converting string to time.but to do the math, will concatenate work? i dont think so. any elaboration on the Calculation..

All are VARCHAR..

Here is another interesting one. I have 4 columns. column1,column2,column3,column4. 0:00:00,0:00:00,0:25:13,0:10:12 I want to add these all columns in transformer,or aggregator, column1,column2,column3,column4, Totaltime 0:00:00,0:00:00,0:25:13,0:10:12, 0:35:25 Any lead.. Thanks for your help.

All, Solved the issue. I tried different alternatives. The actual issue was, As there are NULL values in delimited file.This is not space, it actually WORD "NULL". So, If the function is written as, IF INPUT.COLUMN1="NULL" THEN "0:00:00" ELSE INPUT.COLUMN1, will solve t...

Craig,
When I view the file, it is showing as NULL not space. I used both IF isnull or column1=" ". so that either one should have taken care of.
I know without seeing the actual file, it is more difficult. Let me try once again.

Ok.Thanks, Basically I did a pivot on sql and due to some restrictions i have to put the record in a .csv file.(Input) Input- column1,column2,column3,column4,column5. sam334,NULL,NULL,NULL,07:35:00 Output:-(.csv) column1,column2,column3,column4,column5. sam334,0:00:00,0:00:00,0:00:00,07:35:00 So, I ...

Thanks Craig.
The input file is actually .csv file. thats why probably "" is not working.

Hi all, Have a question. I searched the forum for this but could not find a definite answer. First, I am using ISNULL IF function which is not working. Job is below. SEQ--Tranformer--SEQ(.csv) So, there are 20 columns in input. each column can be NULL or there is a value Datatype, varchar, 0:10:15. ...

Do you want me to open a new thread or use this one.

Yes, but not getting the IF function properly

Craig,
Sort could possible but I am not sure on key field.Input basically has five columns. User,interval,interval1,interval2,interval3. Let me try. Thanks.