DSXchange

I have a requirement to delete a table in Sql server after a job finishes successfully.

I can do this with execute command stage.

Can anyone help with the syntax of the connection details. i tried the below it does not work

delete from Datamart.dbo.sample ;| userid/pwd@servername

Datastage PX version 8.5 on windows(MKS installed): I have the same scenario to implement as noted here. Step2 in the previous post: "2. Exec command activity checking for a file pattern using a if condition. If file found print 'Found' else sleep for some seconds. " I tried the below comm...

For this scenario, below job design works fine. the properties are in verison 8.5. seq file stage1---->Col Gen dummy-->Join On dummy(inner join) ---->Transf---->(seq file output stage1,seq file output stage2) seq file stage2---->Col Gen Dummy---> Seq file stage1 : to read the detail records ( specif...

Source is csv file with the data format as 3/30/2013 09:04:05, reading as varchar(26) . Target is sql server database with datetime datatype . function used StringToTimestamp(Lnk_MapTargetColumns.Date_Received,"mm/%dd/%yyyy %hh:%nn:%ss") getting the below error: APT_CombinedOperatorControl...

Can DataStage gurus focus on this topic? Need your expertise please.

The Manual says "The FTP Enterprise stage transfers multiple files in parallel. " .

I am able to connect only one input link to FTP enterprise stage.

Does FTP enterprise stage does FTP only 1 file ? What is that meant in the manual.

Can anyone help me in this?

Thanks Ray. It works.

Thanks a lot for all your help. I am marking this post as Resolved

Thanks Frank.

I corrected the syntax error in the URI

from
URI = ftp://10.251.245.1/\'TB190S.MAIN.CPEAR\'

to
URI = ftp://10.251.245.1/'TB190S.MAIN.CPEAR'

and this solved the problem.

--- Continuation to the previous post


I did " delete table " in before sql and then insert into table.

I used an ODBC connector stage instead of SQL server enterprise stage , to acheive this delete table request in run before SQL comand and then

From the Job status detail window of the director. There is Job no and wave# alogn with other details like Project, Server and Status.

What is this Job No and Wave # ? How can I extract this information from Job ?

I need FTP 3 files to Mainframes. The job runs on Datastage V8.5 on windows. Can I use only one FTP enterprise stage, to FTP all 3 files ? Is Wild card match possible. Is there any possibility of getting the success or failure message or return codes for the FTP process ? a) success message for all ...

Firstly, truncate table commands can be executed only by the owner. So the DBA's are reluctant to grant the owner privilege for the Datastage user. Secondly, there is a reference for Foreign key to this table. So Truncate table command cannot be used in this case. What is the best alternative for th...

Could you post the structure of the fixed width flat file along with sample data ?