DSXchange

So I did eventually figure this out.

A) There were error messages; I had inadvertently hidden them in my Director log. Doh!
B) The errors led me to adding the $APT_DEFAULT_TRANSPORT_BLOCK_SIZE environment variable in the Job Properties and bumping up the default.

Now, it loads just fine.

THANKS

I have a flat file (csv) with a number field that has varying decimal precision. The numbers in the field could be 1, 1.23, 1.23456789, etc. I would like to round the field to fit the target Oracle table to which I am loading it: NUMBER(20,5). What is the correct way to do this? I've tried several t...

Thanks for the suggestions. Unfortunately, they did not work. I tried running the source directly to a flat file. I ran into the exact same column and/or buffer limitations. I am using basic transformers, but I shouldn't come anywhere near the 8100+ input/output limit. Any other ideas? Are my MAXFET...

I am using DataStage 8 and trying to load an Oracle table from an ODBC connection to SQL Server 2014 using a DRS Stage to pull the source data. This table has 600 columns (yes, I know, cannot control) and the job works for 260. It fails without error at 261. I know the specific #261 column is not th...

That did the trick. Thanks!!

I am loading a sequential file into an Oracle database with a transformer in between. I have tried all combinations of the NullToValue derivation that I can think of, but it is still loading NULL into the Oracle table: NullToValue(LINK.COLUMN,-1) NullToValue(LINK.COLUMN,'-1') NullToValue(LINK.COLUMN...

We have a parallel job that is supposed to load data from a sequential file (SAP extract) into an Oracle database. We recently added a BUNCH of columns to the job and the Oracle SQL Loader control file generated by DataStage in the scratch folder truncates the last third or so of the columns it is s...

I had this error and did a df -k to check space on the file systems on the AIX box. /tmp was full so I cleaned it up and after that I was able to compile jobs again

one thing to note - im the guy at the bottom of the food chain. so i dont have access to the server - ie i cant setup connections etc. the database has been setup on the db2 server (by someone else). the odbc connection on the datastage server has been setup as well (supposedly). however, my problem...

This is probably one of those stupid questions. IBM installed and setup our DataStage and QualityStage. They also supposedly setup our test environment database. We are using a DB2 backend for all of this. I used 7.5 Qualitystage alot, but the test environment thing is new to me. When I go in to con...

Ray, thanks for responding. The solution turned out to be very simple. It appears that while in the process of moving files I inadvertently copied a .Type30 file to the main project folder. Apparently this is a bad thing. I removed the file and all is well.

I have somehow hosed up one of my projects. I think it has something to do with permissions but I am not sure. Whenever I login to the project I get "Cannot Open file UFD". I am able to get into the project but it is protected and I cannot change any thing. I searched and found a post abou...

That was the issue. The Sybase plug-in wanted the field to be defined as a LongVarChar where the ODBC wanted it to be VarChar. Once I switch to LongVarChar everything works.

Thank you for the help.

I am pulling data from SYBASE 12.5 using the SYBASE OC Stage with the Sybase 12.5 client. I am getting the error "The bind of result set item %resulted in truncation". This error occurs, I believe, because the column is defined as a text data type and the data in the column is over 255 cha...