Search found 3 matches

by monishab
Mon Jan 20, 2014 4:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC Connector truncates exceeding length column values
Replies: 3
Views: 2202

Yes.
I do have reject link in both stages Column Import and ODBC connector as well.
by monishab
Fri Jan 17, 2014 8:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC Connector truncates exceeding length column values
Replies: 3
Views: 2202

ODBC Connector truncates exceeding length column values

Hi, We are using SQL Server database with DataStage as ETL. Am trying to build a geneic datastage job to populate multiple set of PSV files using schema file approach. While Loading into Database tables, am trying to validate the data for Datatype, data length and Nullability through individual Sche...
by monishab
Tue Apr 30, 2013 4:52 am
Forum: General
Topic: Field Function in 8.5
Replies: 2
Views: 1320

Field Function in 8.5

Hi, Am a newbie to Datastage and am trying to make use of Filed fucntion to extract the values from a string. Look for the first forward slash starting from the right of the string and take 4 characters to the left of the forward slash Example Data: NTCADTX CAD 3333/ 5930/1 ---- 5930 NTSOLDI EUR 235...