DSXchange

We are trying to import some data from AS/400 system. We setup ODBC drivers using IBMrios-odbc-5.0.050414. When we import metadata on a table that has column of type 'char', Ascential sees it as 'binary'. And when we try to view data from the ODBC stage, it displays the data as '453244344532', '4435...

I am trying to convert Hexadecimal value to Char.

The Hexadecimal value for example is in the format '4040404040404040F1F0F1F9' which is equivalent to ' 1019'.

I tried using OConv with codes "MCXD", "MCX".

Any ideas?

Thanks,
-Anil

We are getting the following error in one of the jobs that uses DRS and IPC stages.

IPC.Result: ds_ipcopen() - call to CreateMutex() failed - The handle is invalid.

Conversion: |Error 11 in GCI Link initialisation.

Any ideas?

When I use IConv with "MX0C" code, its returning "40404 "

The hexadecimal value I am trying to convert is "4040404040404040F1F0F1F9".

thanks,
-Anil

No.its not a COMP field. When I imported metadata for that table, DataStage recognised it as Binary SQL Type.

-Anil

I tried ASCII() as well, it does not seem to work

I am trying to convert Hexadecimal value to Char.

The Hexadecimal value for example is in the format '4040404040404040F1F0F1F9' which is equivalent to ' 1019'.

I tried using OConv with codes "MCXD", "MCX".

Any ideas?

Thanks,
-Anil

7500 means "7500 "Unexpected Network Error. ErrNum = %d1"

The meaning to these error codes are in *.po files. These files are located under /branded_odbc/locale/en_US/LC_MESSAGES.

After giving the correct port number, we are receiving this error now during bind:

Package creation failed!: 1242

Any ideas on what this error means?

Thanks,
-Anil

We are trying to make a connection to DB2 on AS400 server. We made an entry in .odbc.ini file and during bind we are receiving this error message: Package creation failed!: 7505 Any ideas on what 7505 means? Here are the entries from the ini file: [SISCO-AS400] Driver=/ascential/psepm8/Ascential/Dat...

This is resolved. There was a problem in the odbc.ini file.

Thanks Mat for your time,
-Anil

When I try to test the ODBC, we get the following error: SQLConnect: Failed... SQLSTATE = 77 NATIVE ERROR = 0 MSG = 523 76 SQLConnect: Retrying Connect. SQLConnect: Failed... SQLSTATE = 77 NATIVE ERROR = 0 MSG = 523 76 SQLConnect: Retrying Connect. SQLConnect: Failed... SQLSTATE = 77 NATIVE ERROR = ...

Yes, you need to include the default library in the server tab.
Under the packages tab, make sure you have the default package library.

You dont have to install ODBC on all client machines. Its only required on the server.

-Anil

We get the following error when trying to import table definitions. We are making a connection to DB2 database using Ascential's ODBC drivers, IBMrios-odbc-5.0.050414. DSR.MetaGeta(GET.TABLES)(SQLTables): BCI Error: SQLSTATE=S1000,CODE=1248,[DataStage][SQL Client][ODBC][DataDirect][ODBC DB2 Wire Pro...

This problem is solved after changing the timeout on the administrator page and reboot of the server.