DSXchange

Hi,

In my job I want to write a field of char(3600) in seq file.But the field is getting truncated after 1000.
The input is a seq file ftp ed from mainframe.
What is the max length of char we can assign.
Please help.

Thanks
Shaonli

Apparently we are not able to find any difference.Is there any special APT parameter to recognize null value..or do we need to chack character set used by datastage..
Please suggest...

input is A.txt file(10 records) which has fileld C1,C2...char field... ref i/p is B.txt(7 records) which has field C1,C3...char filed.... lookup has continue condition....lookup key is C1... In lookup the o/p fields are C1,C2,C3 now o/p of lookup is 10....(7 records matching) Now in later stage if I...

My i/p is Loc name address 100 a1 abc 100 a2 abcd 200 b1 abcds 200 c1 abcdsa 200 a1 abc 300 a1 abc O/p Loc name1 name2 name3 address1 address2 address3 100 a1 a2 null abc abcd null 200 b1 c1 a1 abcds abcdsa abc 300 a1 null null abc null null Please suggest which stage to use for converting rows into...

So is it not possible to convert in the format I specified if the o/p data type is DATE.Please clarify.

So is it not possible to convert in the format I specified if the o/p data type is DATE.Please clarify.

My i/p date is in the format yyyy-mm-dd.I want to convert in the format mmddyyyy.
Please suggest.Both the fields(i/p and o/p) datatype is Date.

there will be slight change in the o/p 100,10 200,20 200,21 200,22 300,30 300,31 For location=xyz it will get splitted into 3 rows but location code will be different.for 3rd condition also the row will get splitted into two columns and location code will be different in two rows. Please suggest. Th...

Hi, My i/p file has 3 columns.Say Order no,Order Name.Order Location. The O/p File has two fields Order No,Order Location code I/P- 100,A,ABC 200,B,XYZ 300,C,MNO O/P- 100,10 200,20 200,20 200,20 300,30 300,30 That means depending upon Location name the I/p gets split into multiple records. When Loca...

I have just given a example.But in real case the data type are same for i/p and o/p. I can't pass the i/p(apart from those values) for default. The case is that apart from those three condition I don't want to pass record.I just want to end the last Else without giving any value. Please suggest. Tha...

I have just given a example the data type are same for i/p and o/p.

I can't pass the i/p(apart from those values) for default.

The case is that apart from those three condition I don't want to pass
record.I just want to end the last Else without giving any value.
Please suggest.

Thanks
Shaonli

Hi, In my source there are 3 condition for three values.If name=a then 1,name=b then 2,name=c then 3. For any other value will not be considered. Now in tranformer when I am using if then esle the problem is that in the last loop of else I am not able to give any other value as no default value is n...

Thank You for your suggestion.it worked fine.

I need to chek format of a field.If the format of the field is 99-999-9999 then one condition should satisfy.
Please suggest how to check the field format.

Thank you for your suggestion.