DSXchange

We don't see anything in Director. The job start failed The unix logs show the below Status code = 0 Job Status : RUNNING (0) Checking job execution type . . . Multi Instance Job: N Examining job status . . . Performing needed reset action . . . Job appears to be running, or is not compiled. dsjob_l...

Hi, I have an multi-instance job. This job runs with invocation ID A and B. At a time 2 instances of the same job will be running. The issue is , if the job instance A is running and Job with instance B kicks of before instance A completes then the Job with instance B fails. Since its a multi -insta...

Hi, I have to migrate a file from Unix server to Main frame Server. Job1 Sequential File Stage -----------------FTP Stage. Job1 Copies file from Shared location to the local FTP Server. When I open this file on the local FTP server.The data appears row by row. Job2 FTP Stage-------------FTP Stage Jo...

A column has operators as values such as >,<=. In the stage variable I am comparing the values of the column. Here is the Syntax If link.InputColumn= "=" Then lnk2_xfm_cfp_dw_in.EFFECTIVE_DATE = jp_EIS_IOO_CASH_FLOW_PROJECTION_DW_Control_Date Else If link.InputColumn= "<" Then ln...

Hi Brad,

Thank you for the help. Alt-Space worked.

Hope

I am unable to open sequential file stage in Datastage. I had the same issue before.I was unable to open a funnel stage.Datastage will stop responding if I opened a funnel stage.So I had to kill the session. I uninstalled DS client on my m/c and re-installed DS Client and got rid of the issue.The sa...

Thank you all

This is a parllel job

I did use the standardization stage and it worked. Sreedhar, Out of curiousity,could you please explain me how I can use a lookup stage?. If I put the values North,N South,S Suite,STE in lookup file how do I match part of the string ex: I have 2343 South Bay Street with the values in the lookup file...

I have to convert source data by applying the abbreviation rules.

My Source Data is .

Source
2343 South Bay Street
1899 Ranch Building
345 North McArthur Road

target
2978 S Bay ST
1899 Ranch BLDG
345 North McArthur RD

Please help me with the logic

I am using KeyMgtgetnextvalue() to generate a unique number.Once I complete my job I want to reset the value starting from 1. How can I reset the value to 1.

Please advice.

Thank you,

The logic works

I did split the date and timestamp and wrote a conversion for the date .

OConv(Iconv(DSLink4.ModifiedDate[1,10],"D/DMY[2,2,4]"),"D-Y-M-D")

The out put of this function is 15346.Its not giving me the target date as 2010-04-02 .
Is my logic right?Please correct me if I am wrong.

Date formates are as below

Source Date =04/02/2010 01:00:05 AM and I have to do some conversion and Target Date should be 2010-04-02 01:00:05.000

I have to load Date(Flat file as source and datatype as Timestamp (23,3))
ModifiedDate = "04/02/2010 01:00:05 AM" in to
Target table (SQL table as) "2010-04-06 23:50:46.000"

Can anyone please help me with the conversion


Thanks
Hope