DSXchange

Yes, that helps. We are an Informix shop and I'm used to having to have an entry in .odbc.ini for any connection to Informix databases. So in practice it is possible to access Oracle 9i, both local and remote, without any entry for oracle in either .odbc.ini or uvodbc.config?

Steve

Craig,

Okay. Now where do the Oracle and Oracle wired drivers within the .obbc.ini file come into play? I feel like I'm back in 1st grade here .

Steve

Craig, I tried the metadata import with OCI9I in manager, but the DSN pull down box did not list the DSN I setup in the .odbc.ini file. Do you know where the DSN drop down box gets populated from? There is some mention of sql*net in the DS plug-in Install and Config pdf, is this part of UNIX or part...

Good morning all, I seem to be having problems configuring DS7.1r1 on HP-UX 11.11 to use the Oracle 9i plug-in. I have ORACLE_HOME pointed to what I believe to be the correct directory. And have $ORACLE_HOME/lib32 included in SHLIB_PATH. When I try to use the DSN within UV with DS_CONNECT I get an e...

@athorne I ran into the same issue while upgrading from 5.2r5 to 7.1r1. If you followed the upgrade information to the tee, then you may have a problem with the lib_path entries made in the dsenv file. I'm running on an HP-UX 11.11 box and the install instructions suggested to add something like LD_...

Virginie, Are you using the ftp stage to retrieve the data from the AS400? Is the packed data similar to this example: base 10 # expanded hex value virticle by byte followed below +12345 = 135 (3 byte source field) 24C or 0135 (4 byte field) 024C If you answer yes to both questions, then the solutio...

Jim, Trim by itself without options defaults to option r I believe. This may be giving you problems since the r option removes leading, trailing, and multiple occurances of space and tab(unless another character is specified) within the field. example: trim(" this text ")= "this text&...

Jim,

Out of curiosity, what form and options of trim are you using?

Steve

Thanks Ray, Peter, Aravin, and Roy. We have limited exposure to AS400, hence we conveniently allowed our DBA support team handle DB2Connect administration. So I will continue to use the long method as Aravin mentioned.

Steve

Ray,
Can you enlighten me on the filters and there location.

thanks,
Steve

We are running 5.2r1 DS on UNIX and using DB2Connect to connect to AS400. You probably have everything setup correctly, because it takes us over an hour to import table defs. We have very limited use and no need to invest time in better performance. Just make sure you don't hit cancel or the wrong t...

Why do they have to be put into 100 hash files rather than just one hash file?
If all file layouts are equal, then maybe you could tack on an indicator to each row, concatonate the files together and load into one hash file.

Just thinking out loud.
Steve

Perhaps you could perform a multi-row lookup (described elsewhere on this forum) and use a stage variable along with a comparison to last row written to add a look-up/sequence number to all output. Then use another transform to count or manipulate the rows based on this sequence number. Just thinkin...

If your data does not allow for an easy way to detect the last row or if your data is out of order, you can resolve the pivot with summation. When you read in a row you need to write it out with key fields followed by the columns you want to pivot. Each of the pivot columns will receive either a zer...

Hi, You can also use the ftp stage to perform a binary transfer into a transform stage where you can use the ascii routine and the other data conversion routines to handle any binary or packed ebcdic data. The trick to using the ftp is in the length and display values in the columns tab; the length ...