DSXchange

Thanks Ray and Craig. I will try and update it asap.

Ray,
Input is delimiter file and output is DB2. So, basically its a huge file and put in unix server as .DEL. we pull it up from there using FTP plug in. And data type for input and output is DATE.

All, Need a help in date conversion. I know this probably has been discussed before but could not figure it out. Here, the input column and output column both are DATE data type. Input is '2014-12-10' and out required is 12/10/2014. We have the server version where we use, ICONV(Column1,"D4-YMD...

Thanks a lot..,.Worked perfectly..

I have 5 rows in input table. and the format is like that, Date. code, count 2014-12-10, FINANCE, 150 2014-12-10, MARKETING, 200 2014-12-10, HR, 300 Now, the source is a table so, in one day there possible wont be any counts for HR, but in target file we need HR with count 0. In query I got it, but ...

Sorry for the delay. Found the issue. We do not use external scheduler to run a job. What we do is, have one LD_JOB which includes the job design and we will have a dummy job named Job control which calls that LD_JOB. In server environment this was the case but not in parallel. So, it was giving the...

Hi all, I am having a parallel job load which executes from Job control. So, the Job control does have only one job. When running the JC, Load finishes but after finishing the job it is giving a warning main_program: Step has no operators [api/step_rep.C:1530] What does it mean. Though when use serv...

Thanks for all the help. Found the issue, it was in VB script email sent commands. There was a space and believe datastage was executing differently than in manual execution.

Thanks.

Craig,
Nope.. It simply sends the file and we get the transmission successful email.

Ok.Thanks Ray. But if this is the issue then when I run it manually it should not be working right. It works perfectly. Only issue is running from DS

All, I have a windows batch script which sftp a file. Now manually I am able to send the file but when used the script in After Job Subroutine, the job hangs. Basically it is not working while executing it from Datastage after job sub routine. Is that an issue Admin should handle? Any other option t...

It will be a concatenation of Certain and Believe

I used the FMT code above. The output is 00:00. The input column 1.15 and 1.22 are varchar(1) and varchar(3). And the output data type is same. Do i need to change the output data type to time or anything..

Thanks.

All,
It is a calculation of time taken to attend a call. So, there are actually all calculations in SQL query which gives the result of this. I found from january the value never crosses minutes border.

So, we believe, it will be always m.ss format.

It is always be 1 minute 22 seconds. The way data is right now, it is not going to be hour.

I mean, it will be minute and second.

All, Have a question on time conversion.

From DB2 DB we pulled calculated some total call time and columns are like

Tot_Time Tot.Attend
1.22 1.51

I need to have hh:mm:ss format. Is there any way we can convert it in datastage.

It should be,

00:01:22 and 00:01:51

Thanks,