DSXchange

Hi guys/gals I have two servers that need to communicate to each other on dedicated network cards. This I can do, and have managed to map drives to and from each server. On windows level (windows explorer) I can create files on the mapped drives from the linked servers, meaning that on each side, I ...

Hi Peter and those who assisted! It turns out we need to download the latest service pack (SP) for V5R1M0. The SP is available here: http://www-1.ibm.com/servers/eserver/iseries/access/casp.htm I installed the SP and all is working well on the server. I just need to test whether a client can connect...

Thanks Peter I did set that setting, but it still truncates the data. Further investigation shows that the V5R1 client access needs a patch, as described on this page: http://www-912.ibm.com/s_dir/slkbase.nsf/ibmscdirect/D690467348A96C3386256B27005532E9 As soon as I have this patch and tested, i wil...

hi 1stpoint - this odbc trace is when i import metadata through datastage manager.

the topic was... http://www.dsxchange.com/viewtopic.php?t=87880 I took the advice earlier on by ray.wurlod to limit the table definition import - i did this by specifying only one table that i know only has 4 columns and 1 record in, but i still get the BCI error of data truncation upon importing me...

In the sequential file stage, use the 'Append' option, instead of the overwrite option.

Now theres a slight twist in the tale. As mentioned in my previous post, using the v3 odbc driver i can retrieve the table definitions on datastage 5.2r1. when i move up to a newer odbc driver, i get the truncation warning explained in the 1st post on this topic. the plot gets thicker; when i connec...

Try using Iconv to get the time to an internal format, do the calculation and then Oconv the value to the format you need.

the help details iconv/oconv quite well.

dnzl

You mention that you are matching the hash to the flat file, are you sure there are records in the hash that match to the flat file? (i am assuming the flat file is the stream input and the hash the reference input). if you are certain the records should match, try get the data that needs to be matc...

this is possible if you are willing to use variables, the way we did it was to have several 'control' jobs pass variables to each other and so react based on the variable values recieved/passed. will variable passing help? i.e. we have batch A and batch B. Batch A consists of job 1, 2, 3 and batch B...

it sounds like you have two oracle databases you want to update that reside on two different servers. seeing as you already have one database defined, you will need to define the next by editing the project uvodbc.config and $dshome/.odbc.ini files. if you can more those files you will be able to ed...

aaaah! some feedback... using a newer odbc driver (5) to the as400 (DS5 and DS4.2), i am experiencing the problem explained earlier, yet on datastage 4.2 using an older ODBC driver (v3) it seems not to be a problem - i can import metadata, view data and almost have it make me coffee. I am now instal...

Hi Peter Thanks for that 'do not request sqlconnect', that would have driven me up the wall. i have created a job that i manually entered the column names and data types - one char, and two numeric and i can view the data - thus accessing the data this way is no problem, only tedious. when i want to...

Just to add to this..

I can actually design a job that reads from the AS400 source by bypassing the 'import table definitions' stage.

So its an isolated problem to the DataStage Manager.

denzil

Hi all I have managed to set up the ODBC to the AS400 of the client and can connect and query using winsql - so i know i can get the data. when importing metadata through manager (using ODBC table definitions), i get the following: DSR.MetaGeta(GET.TABLES)(SQLFetch): BCI Error: SQLSTATE=01004,CODE=0...