DSXchange

For every day run, I have to truncate the target table before loading. The job runs on a 2- node configuration. I am using a OPEN Command in the SQL server Enterprise stage. DELETE FROM tablenameA; This is not working . Looks like I cannot use a commit in open command. whats the feasible approach to...

I have to FTP a fixed width file from Datastage( windows server) to the Mainframe system. The file is GDG based in mainframes. Job design: Seq file ( fixed width file) ---> FTP enterprise stage Fixed file name : B190S.PBAS.CPEAR.P(+1).txt Dataset created in mainframe: TB190S.MAIN Properties set in F...

can anyone help me to understand the director log ( information message) on all the columns of the table for the multi instance job.

Different Code page options are : Default,Unicode, user-specified. Selected Default. From the manual: Default means "The connector expects the data to be in the code page of the engine operating system where the connector runs. If a different code page is used, the connector converts the data. ...

I use the Generated SQL for the job. The code page in the ODBC_connector stage is set to Default. i am not able to see the character set property ? Where is this present? This is not a warning message. this is an info. For each run of a reference table, it gives info message for all the columns. I a...

I have requirement where the source needs to be looked upon 3 reference datasets to get the related value. Conditions : dataset1: source_col1=dataset1_colA source_date1>= date_A and source_date1<= date_B dataset2: source_col2=dataset2_colb source_date1>= date_D and source_date1<= date_E dataset3: so...

There are 20 reference table (Sql server tables) that are to be loaded to 20 different datasets. The table structures are different and all the tables are in the same database. A single table may be required to be executed at the same time in different sequence jobs. A table will be executed only on...

Thanks everyone for your help.

I am able to run the unix command, so it means MKS toolkit is installed.

I close this post, marking as resolved.

Thanks for your reply.

I need the record count in a file. Yes it creates a empty file when there is no record.

I am not able to understand the solution that you had provided. Can you please elaborate more.

In the sequence job Job activity1 ------------------------------> Job activity 2 In the triggers of the Job activity I call the DSGetLinkInfo routine 1) LinkExecSeq: Custom( conditional) : DSGetLinkInfo(Validation_Job,'Stage name', 'linkname', DSJ.LINKROWCOUNT) =0 2) LinkExeJob:Otherwise : Email not...

can anyone help me in fixing the issue.

I am getting the same error. Searched in couple of forums and could not find any resolution.

Requirement:

Job 1 creates a file . File is in windows server
I have to trigger job 2 only if job1 file count =0

The Datastage server is installed in windows. I am accessing datastage through citrix client. How can I check if MKS Toolkit is installed?

Do I need to use the nested activity? Can the logic be acheived as below. Job activity1 ------------------------------> Job activity 2 In the triggers of the Job activity can I directly call the DSGetLinkInfo routine 1) LinkStopSeq: Custom( conditional) : DSGetLinkInfo(Validation_Job,'Stage name', '...

Can we supply current date ( todays date) as a parameter in a Parallel job.
Can I do this in Sequencer.
What are the ways to do this ?

The requirement is to pass the output value of the routine to the next activity, based on the value of the output. Routine calculates the link count of a particular link of a job. I calculate through an after job subroutine( after job successfully completes). I have to execute the job based on the l...