DSXchange

hi jwiles,

now i defined the lengths as 444 and 756 respectively for the fields and i am getting the 1200 bytes data.

thanks for your suggestions....

yes ,i am able to view the the file using the other tools.

Hi Jwiles,
i am a junior Datastage developer,learning ...

Here is the layout for the fields:
i didnt define the lengths of the fields below,they are fixed lengths.

fixedrec1 varchar
fixedrec2 varchar

i tried using the char,but still getting the truncated data for the last 247 bytes of data...

Hi all,

As per my req i need to get 1200 bytes of data.i want to know is there a max limit for the data because when i run and see the data in the Datastage then i get this issue:

"Warning : Data that exceeds the maximum display length has been truncated"

HI JWILES,

I didnt understand the question...
Do you mean the format for the output file ??

the output file has 2 predefined fields named "fixedrec1" & "fixedrec2"

the format is varchar.

Hi Jwiles,

i am writing the output to a Sequential file.

i am populating the Additional Spaces i.e; 756 within the transformer.

the Derivation is - Space(756)

Hi All, i am generating a text file as an Output with the SIze as 1200Bytes. i have data for the 444 bytes of data and as per the Req I have to append 756 bytes of remaining data with Spaces. My question is when i hard-code the 756 bytes of data with the Spaces and Run the job and see the text file ...

Thanks Pandeesh & Jwiles...

i converted and now it works fines as i desired.

Hi All, i have a field named - "ITEM_SEQ_R" Num(5,0),the values for the field in the Sql database are 622,355. when i use the above field and generate a text file then i get output as ' 00622.',But i want the output as '000622.' when i concatenate a '0' then i get '0 00622.',So my question...

Hi ALL, i want to know can the Datastage generate the Packed decimal format... i have a input data in decimal format but in the output i have to generate a text file with the packed Decimal format for the Decimal i/p . Please let me know what kind of conversion i need to do...so that i will explore ...

i got it fixed...

used the convert Function...
Here is the syntax :

Convert(".","-",READ_Data.ITEM_R):

Hi All, i am having one of the column named in a Sql table named - 'ITEM_R(Numeric (5,0)).there are 2 values for this column i.e; 3,131 & 5,243 Now when i pull this column in the Data-stage Extract and see the data then i see the following values i.e; 03131. & 05243. so my req was to replace...

Thanks Jwiles....

Hi all,
i have a field Named - "Buss_unit(varchar(5))" which display the values as Null,12,20.

Now my requirement is that i have to define a constraint in the Transformer to Delete the rows with Null values...

Please help me the syntax.

thanks will give a try...