DSXchange

I am not understanding Why is this ambiquity? How should we determine the context in which these TO and from are to be used ?

Hi , I am using the modify stage to specify an explicit conversion function as follows Specification =Col_name =DecimalToString Col_name But i am getting the job aborted due to this with the following error main_program: Error parsing modify adapter: Expected ';' or end, got: "Col_name" Is...

Hi , I accept that the decimal place holder is essential for identifying that the number is not an integer but the metadata is Decimal(11) and when i view the data it is showing as 000000000121. . It has read all the 11 digits but still displays a . after the data. Provided its padding Zeros in the ...

Any clues on this please

Hi, I am sorry to report the unclear issue in my earlier post. The Level number in the mainframe metadata is changed to level number-1 when its loaded using designer in to the CFF stage. When i save the table definition in manager its level number is intact ie in Table def of manager it states level...

Hi , I am saving the table definition of the mainframe fixed width file which is in EBCDIC format. The actual mainframe metadata has a level number of 02 but when i save the definition of the mainframe file the level number goes down. ie original metadata is at level 03 but when i save the level goe...

Hi,
Could anyone tell me of what this error means during the import process. How shall i debug with this warning ...Clues please

Hi , I tried to run the parallel job that has the same metadata as the server. S.NO COL NAME NATIE TYPE LEN ============================ 1) DT_RECORD_TYPE DISPLAY_NUMERIC 1 2) ACC_NUM DECIMAL 11 The server job goes fine but the parallel job throws import warnings as below FileName_cff,0: Field "...

Hi , I have saved the table definition of the mainframe file available in the server job and i am using the same in the parallel job.The file which i was able to view from the server job with out any problem is showing some movement in the data when viewed from the parallel job. metadata in the serv...

Ray , I am Pointing to my col generator option. I have not used the modify stage option. Since i have used the col gen for most of the skeleton designs that i have developed ,i am finding it bit a difficult to change . . . .

Yes Ray , i would be able to use it , but my simple logic to generate the date field fails , i am not sure why its generating this value ....Is there some prediction on this ?

Hi , The first option of using generated date column in the preceeding stage is not possible as i dont want to use a transformer. The second option is helpfull.But i require some help on this please .I have used the cycle algorithm ,initial value as the job parameter and the limit as 1 ,so that it c...

Hi , I Have to generate an additional date column in the stream of processing .The date column would be acquiring the value from the job parameters.Can this be achieved using modify stage also . Please suggest ... As i dont find any explicit value specification in the modify stage,i hope modify will...

Thanks everybody for the contribution As said i have used the left(trim(column))="" in the constraint section of the output link to segrgate the reords for which i have got null values in the left outer join. But certain things i dint understand which i am narrating below 1) When i concate...

Hi My Left Outer Join Brings a Varchar Column populated with some unlnown value when there is no match with the key column . I would like to filter the records with these Unknown values for subsequent processing. I have tried to check as follows If trim(column) ="" Then 'Y' else 'N' and i ...