DSXchange

sorry but i didnot get it.

Can u specify in detail

Yes, integer values come across the ODBC interface correctly.

As mentioned earlier i am facing problem only with varchar fields.

Under columns tab

For other datatype the resultant is correct.The problem persists only with varchar fields.

And i am using the default NLS setting specified at project level

But i have even tried with different NLS setting but the same result(Value truncated) is encountered

If at all i click on view data then the data is proper( i am able to view total length data) but if at all i run the job with specifying current length descriptor then the resultant has only the first character and rest of the character is truncated

Driver=/usr/lib64/libmyodbc5-5.1.5.so Setup=/usr/lib64/libodbcmyS.so.2.0.0 Description=Connector/ODBC 3.51 Driver DSN SERVER=192.168.168.58 PORT=3306 USER=root Password=abcd2012 Database=abc OPTION=3 SOCKET= DriverUnicodeType=1 Note: we even tried changing DriverUnicodeType to 2 but same result. Whe...

-Yes it displays abc -There after viewing it in linux environment it displays "abc" Nothing to do with sequential file problem persists some where around ODBC I even tried to concatenate the value from DB say i/p col has NoOfTopPerformers, i concatenated the value 123 to it but the output ...

3.After writing to a sequential file the strings are truncated.

5.After creating a dummy job by giving string values in transformer stage i am getting some junk characters like 獡晤獡晤獡晤獡晤獡晤

ODBC drivers for MySql used in our UNIX system is 5.1.5 and have also tried with 3.5

Please find the details below: 1.Datatype in mysql is varchar and length - 50 2.Datatype in ODBC stage is varchar and length - 50 3.View data in the job works fine with full lengh. 4.I think we are using ASCII characters. 5.No,If we write to a mysql database using the same ODBC settings, no strings ...

Hello all, I am using Datastage v8.7(server job) and while using ODBC stage in server job to retrieve data from Mysql database. Varchar fields output only the first character and rest of the characters are truncated. This issue is with only server jobs in linux environment,it works fine with paralle...

Well thanks for your reply,

But i have to use the same job for mysql and oracle and i have found a workaround, if i add a key word Timestamp before the date it works for most of the databases, but doesnot support MSSQL

Any option to work with it globally for all sets of jobs.

Can you please mark it as non premium content!

I need the conversion at first stage i.e., odbc connector - I am using a SQL query where i am fetching data between two dates(last_run_date and current_date) where the current date is passed from the sequence job(i.e., DSJOBSTARTDATE) which is in the format %yyyy-%mm-%dd, but to get the data from th...

My requirement is to load data with the same job using ODBC connector to oracle and Mysql databases,but i am not able to load due to date format issues. So for that i need to use the same job to load data with the format supported by oracle i.e., %dd-%mmm-%yy. Please Help on this. And can u tell me ...

After modifying the date string in job properties "Defaults" tab at job level to %mm/%dd/%yyyy and then using currentdate() in transformer stage in data stage parallel job Resultunt date value obtained in %yyyy-%mm-%dd format But i need the resultant in %mm/%dd/%yyyy format What i need to ...