DSXchange

Sorry, I was not able to read complete message as I did not pay. I am going back to Unix command CSPLIT or NAWK

Thank you again Ray

battaliou wrote:This is a classic server job using a type 1 hashed file. It will generate any amount of files you like.

Thank you,

Can you please throw little more light on it?

ray.wurlod wrote:So is it that you want a new file to start each time a line beginning with "A" occurs in the source file? This might be easier and faster to accomplish using a stream editor such as sed or ...

Thanks, I know awk or nawk works. In my question I asked logic in datastage not in unix.

Can anyone help me in getting this logic implemented using datastage please? Below is the what the main file looks like A200198565634 B769348348547 B837563487567 K656895565906 A387562985749 B893745647875 B394857348957 K734564735644 A893745634785 B938457348953 K783456347856 A890345765875 B37894563478...

Thank you for the reply, I have filters used while reading a file. If I use schema file then I am not able to use filter scripts.

Is there any way converting file layouts in excel to sequential file definitions in datastage I have like following: Name CHAR 1 Address CHAR 80 City CHAR 80 What I do so far is just copy column names in another sheet as a single row and export as delimited file then manually select data type and en...

I am planning to implement a sequence failure if audit process does not match, where the record count using datastage does not match with the count in trailer or header of the file.

Any input in suggestions or previous post links are greatly appreciated.

I am extracting data from EDID4, can anyone know the equivalent data type I need to use in datastage ABAP extract. The field name is SDATA with LCHAR datatype

Thank you Chulett and Arvind, I never did scheduling in Director and was using scripts but all of the sudden due to security issue we planned to run jobs using director.

That helped me with all your inputs. Appreciate it.

I just want one email notification for all jobs at the end with all the job details(Failed/Okay). The number of jobs may not change and I scheduled in serial so far and trigger with unconditional as they are not dependent. I understand the shell script permission. The server has high sensitive data.

Thank you for the reply, I cannot execute shell due to permission. Is there any way in Datastage director without a script.

I have 42 datastage jobs need to be scheduled one after another using Datastage Director and add an email notification. Can anyone help me doing this.

What I did so far is I added 42 Job activity stages in a Sequence Job but I want it to make little simple.

Thank you.

Varchar(max) is not a supported data type in datastage.

Can you split the job into 2 jobs and check?

Can anyone help me in extracting SQL Server VARCHAR(MAX) columns with datastage?