DSXchange

We have made many different attempts to get rid of this pesky msg in our Oracle Load Enterprise stage. We have failed and have been forced to demote to informational. For the record we are doing: Oracle Enterprise (on AIX) stage,; set to LOAD;TRUNCATE; APT_ORACLE_LOAD_OPTIONS set to : OPTIONS(DIRECT...

I haven't messed with the environment variables yet... I hoping to avoid that. Its a big pain in our environment. I'll check the binary editor route first.

The job isn't creating a fixed length record. All the data looks correct, but its not padding out the columns to fit the column's definition. I'm looking at the files in UNIX and they look as if I created them as VarChar Columns.

I'm trying to create a fixed length record, but can't seem to get it to work. I have selected the "Record Length=Fixed" property within the Format tab, all the columns are set to char data types. Any clues???

I'm not going to get fancy here, but here is a quickie we used to identify pid issues on our box: UNIX This used 2 routines, one before and one after. This code is ONLY to show basic approach for others who want to do something similar, so please don't post complaints about it. variables are identif...

Thanks for your reply we have somehow resolved this with the dsenv (but not sure how ha ha).

Help with a osh config issue pls... We are using the DRS stage, to connect to a PostGres DB (via ODBC) in a Parallel job. The User defined variables for the connect string, user, etc are being written out to the osh script as #DSCAPIOP__STG_DBNAME# (etc) and causing a connect failure. We have tried ...

Really how hard is it? It is after all an object with a state.
This is a really irritating bug.

never mind all! figured it out!
put dbms server output into a variable and passed
out with the output argument, then wrote it to the log.

Hello all - I am using the oracle stored procedure stage to build partitions based on passed arguments. This all works fine, but I am unable to capture the server output (the procedure makes calls to DBMS_OUTPUT.PUT_LINE('Partition not created');). (as an example). Can anyone help me out? Is there a...