DSXchange

Thanks Ray. This is not a interview question. I did a search in help and I could not find any details on the reasons of the rejects in a sequentila file stage, so I posted in the forum. I have a requirement to read a sequential file ( csv file ) and load into target file. As per the metadata of the ...

In the execution command task i gave the command findstr /R /N "^" D:\APP_DATA\VBS\PAS\CIA\REJECTS\SOURCE\ALISSourceRejects.csv | find /C ":" In the log i see the below error: test_seq..JobControl (@Execute_Command_0): Executed: findstr /R /N "^" D:\APP_DATA\VBS\PAS\CIA...

Thanks Craig. You are right. The actual command is : findstr /R /N "^" filename.txt | find /C ":" I used this in cmd prompt and it was giving me the expected result. When I execute the above command through datastage thro a execute command stage, it was throwing error. For more i...

Can anyone explain me the below question.

What all the possible reasons, a sequential file stage will reject data to a reject link.

Suppose I have 4 columns as below

Col1 varchar Not Null,
Col2 varchar Null,
Col3 varchar Not Null
Col4 varchar Null

Thanks Craig for your prompt response.

I need to write the windows script to get the file count.
What is the error in the above command, what am i missing ?

I started with the execution command activity to count the no.of lines in a file in windows command. I am new to windows scripting. There is a file with rejects data, I have to get the total no.of rejects in afile. I am using the below command in the execute command activity. findstr /R /N "^&q...

I have to execute a job based on a file count.
If the file count =0 then execute the job
Else if file count > 0 then send an email and stop the sequence flow.

how to do this in Sequencer?

Can you specify the datatype and length of this column in DB2 and also in Sequential file that you created?

Frank,

thanks for the explanation.

I imported of the COBOL copybook in the same way as you had mentioned. when it imported the
S9(9) COMP field is imported as INTEGER(9)
S9(4) COMp field as SMALLINT(4).


So I am not sure, why datastage converted this way.

How to convert a date format mm/dd/yyyy which is coming from csv file to yyyy-mm-dd to be sent in fixed width flat file. Source data changed to target 6/1/2012 to be 2012-06-01 12/1/2012 to be 2012-12-01 6/25/2012 to be 2012-06-25 12/12/2012 to be 2012-12-12 How to do this conversion in datastage?

Thanks Ray for the answer.


Will there be an impact in the performance for using BASIC transformer in PARALLEL Job(I use 2 node config ). I will be processing more than 1 million records. Is there any other workaround to handle through functions in PX job?

I am creating a fixed flat file, I have around 10 columns with one date column in it. I have declared all column as CHAR in fixed flat file. I do a date conversion from MM/DD/YYYY to YYYY-MM-DD format using stage variables for this field. I was getting expected results and was working fine. Function...

Frank, For the Mainframe DB2 column say PERSON_ID is s9(9) COMP. My requirement is to populate zeroes in to the fixed flat file for the column. I gave the datatype for the column(PERSON_ID) in Datastage sequential file as CHAR(9). Populated 9 zeros in it in a fixed flat file in ASCII format . The ma...

I have requirement to create a fixed flat file with hexadecimal representation only for few of the columns. Is that possible with sequential file stage, if so could you please tell me the properties to set to acheive this ?. If not what stage I should use to acheive this? Please help, if anyone has ...

Thanks Ray. I have added the reject link to a sequential file to capture the rejects. The issue here is records are not getting rejected to the reject file. It gets processed as a good record and is loaded into the target. The below 2 records ( that does not fit the layout)flows into the target alon...