DSXchange

Can you please provide stage level logic to do the same, cannot get what you are trying to say.

The rule is as below: For Column 1, the default value should always be 'US' but i have 100 jobs with this logic and around 100 fields. If i want to change the default value tomorrow, I will need to modify in 100 jobs. Instead, I can just modify a reference file, which has the default value and my jo...

I have a reference file with the details of the fields as below: field name, default value, length col1, US, 10 col2, UK, 35 col3,, 10 I have the input file as; col1, col2, col3 US, UK, NNNNNNNNNNNN US, uk, BBBBB US,UK,AAAA The first 2 records will be sent to error as the length for col3 does not ma...

Have tried that but change capture did not give the expected results.

We need to compare two different files as below and output should be the record no. and the field name which does not match with the before file. Also deleted records from before file need to be captured. All fields are Nvarchar & we cannot sort the fields based on key field col1 as sequence is ...

This was working fine for previous 3-4 executions with same source data.
Why such behaviour now.

Can you let me knw how i can start JOBMONAP on windows

Read all the APT_NO_JOBMON related posts's to find the reasons why jobs are stuck at ready state. Verified the below settings but no chnage. Env. Variable $APT_NO_JOBMON is set to False and value for parameter $APT_NO_JOBMON in DSParams file is: APT_NO_JOBMON \Parallel/Reporting\3\Boolean\0\2\Projec...

When i update teh delimeter to |, i can see 10 fields. But when i try to load he table definition in Complex flat file stage it prompts with below error:

##E IIS-DSEE-TOIX-00179 13:00:52(010) <I90_ADRCLM,0> Import error at record 1.

The modified file is as below: | Branch | 01 A | POLBRK | 1 | 2 | A | 2 | | | | | | | | | | | | Product Type | 02 A | POLTYK | 3 | 5 | A | 3 | | | | | | | | | | | | Number | 03 A | POLNOK | 6 | 12 | S | 7 | 0 | When i try to import the file as sequential file definition, by default in the format tab...

Modified the file as below but the same error. | Branch | 01 A | POLBRK | 1 | 2 | A | 2 | | | | | | | | | | | | Product Type | 02 A | POLTYK | 3 | 5 | A | 3 | | | | | | | | | | | | Number | 03 A | POLNOK | 6 | 12 | S | 7 | 0 | Can you please let me know what is the expected format when seen in textp...

The text which i have pasted above is teh one seen via textpad.
You will be able to see the same via snapshot .

Agreed that the file does not have ".CFD" suffix. But based on teh code what can be teh file type.
And howcan read these columns

Some file portion: ***** ABC TESTING ***** 20/08/10 at 3:43 pm SY039 F I L E L A Y O U T U T I L I T Y Page.: 1 Library: PLDUSRA File: YELBOK Selection: YELBOK____ *USRLIBL__ Record : RYELBOK Text: YEL Book Length : 349 Type: Physical file Access path: Keyed FIFO Unique __Field_text_________________...

The layout file "Download" does not have any extension.
And while importing via COBOL it prompts for below error.

File Contains no table definition (01 level is not found). C:\............\Download

Hi,
We have received an Layout file of an ebcdic file. We can open the layout file in textpad to view the column and its details.

Can anyone please let me know, how can we import the layout file in Datastage to load the column details of the ebcdic file.


Thnx
Arpana