DSXchange

Please suggest a way to convert double-byte string to single byte string in DataStage. This conversion is required to match the data with the existing data in DB2 Ex: ＢＭＷ(Double byte string) to BMW(Signle byte string) Source is CSV file DataStage version 8.7 DB2 Unix Please let us know in case of an...

Thanks Craig!

Will you please help on below requirements: Check valid decimal and Integer fields in DataStage,reject if not valid. Some special charaters are getting Decimal fields from source(XML),we would like to populate valid decimal data into database and capture in valid data into file/table. Source:XML fil...

Thanks Eric.
Yes checked outside the DataStage environment also character looks '?'.

yes,both source and target are unicode characterset.

Thanks Craig!
Characterset used in UNICODE.
Please let me know in case of further questions.

Please share your inputs on the issue. INPUT: CSV file SOURCE COLUMN A =V671U050117 (VARCHAR 50) SOURCE COLUMN B=21 (VARCHAR 20) OUTPUT Derivation: TARGET COLUMN X (VARCHAR 256) =SOURCE COLUMN A : '_' : SOURCE COLUMN B Expected OUTPUT:DB2 table V671U050117_21 ACTUAL OUTPUT: V671U050117?21 _ is loadi...

Yes this is stupid requirement from Customer.
Thanks Atul for your help.

Below transformation function working for me.
DateOffsetByComponents(%basedate%,%yearoffset%,%monthoffset%,%dayoffset%)

DateOffsetByComponents(CurrentDate(),-1*INPUTFIELD,0,0)

Please help with below requirement-

Transformer stage below field needs to derive-

BIRTH DATE=CurrentDate() - AGE

Ex:AGE is 38.
BIRTH DATE is DATE field.

Please provide your suggestions for below issue in DataStage 8.7 Seq File --->Transformations --->DB2 stage Input:CSV file 5968485627(looks in both sequential file stage and Unix) Output:DB2 table Actual: 5?9?6?8?4?8?5?6?2?7(looks in the DB2 connector stage) Expected: 5968485627 Datatype of both the...

Source data(CSV) 自動車搭傷保険料 Target DB2 table: ??R??d?P?Oz?e Junk data inserting into DB2 table through DataStage 8.7 NLS used is SHIFT_JIS Job design: Seq file -->Tranformer -->DB2 Stage Where do you see the problem is? What are all the possible ways to fix the issue Kindly share your suggestions.

The CSV file created by someone else.
I have been updated that the CSV enabled for Japanese characters created under unicode.
Your previous post seems to be premium content which it couldn't see completely.
What are the options available now? Please suggest.

Thanks Ray!

Converted XLSX to CSV and the CSV enabled to support Japanese charaters.
Now after moving CSV file from Windows to Unix,same CSV file showing Junk characters inplace of Japanese.
Tried with both Binay and ASCII mode of transfer from SSH Tectia File transfer.
Kindly suggest.

Facing issue in reading Japanese data in .xlsx format.
Tried to convert .xlsx to .csv,csv file converting Japanese charaters to ?????

What are the options available read/process the .xlsx(Japanese) data in DatStage 8.7(DB2 and Unix)

Please suggest.