DSXchange

All, I have the following job DB2 Stage ------> Transformer -----> Sequential File The sequential file is comma delimited. However I have a field which is of type longVarChar and had commas inside the data. I had been getting the "too many columns in a row error" which I could fix by speci...

Any suggestions in performing outer joins in Server jobs other than defining a user defined query

--Bob

All, I'm trying to use the execute command activity stage in building my sequence. The stage specifies two parameters 1) Command 2) External Parameters I'm tyring to execute the rm -r /home/a/b/c Could you tell me how it fits the description. Also would the above command needs to be prefixed with a ...

Thanks Bala

Your analysis was superb....!!!!!!!!!

Hello, The following was the ODBC set up for Oracle on the DS Server [e1dev] Driver=/home/dsadm/Ascential/DataStage/branded_odbc/lib/VMora20.sl Description=DataDirect Oracle Wire Protocol ApplicationUsingThreads=1 ArraySize=60000 CachedCursorLimit=32 CachedDescLimit=0 CatalogIncludesSynonyms=1 Catal...

KC,

I have been trying to looup for data at the manager. I tried looking at data at the server and found out that it was asking for a password to connect to the database.

--Bob

Bala,

Do you mean that I will have to lookup at the Data Direct DSN setup on DS Server for Oracle...

--Bob

Bala,

I checked the fields and they are the SQL defined types. I also ran the query at my Oracle Client and it works perfect. Do you think it might be a problem in pluging in Oracle with DS.

--Bob

All, I'm able to import metadata into the DS Manager but I'm unable to view the data. This is the error message I'm getting: DSBrowser..DSBrowser1.DSLink1: DSD.BCIOpenR call to SQLExecDirect failed. Statement was:SELECT X,Y,Z FROM ABC SQLSTATE=S1C00, DBMS.CODE=0 [DataStage][SQL Client][ODBC][DataDir...

All,

Is there any way the individual job logs created for every job be sent a named file on some server.

-- Bob

Deepak,

The Later.

Bob

Deepak,

I understand that it can be done with the Director by clearing the individual logs. But can information be stored for period of 30 days.

Aditya.

Hi,

I want to know whether Datastage can maintain individual job Trace message logs and Error message logs for a specified period of time(around 30 days...)

Thanks
Bob

Hi,

Should the source files being processed via ETL should reside on the ETL server or database server.

Thanks
Bob.

Hi,

Can DataStage can access .xls or .mdb files in a UNIX directory via ODBC connection or do we need to create a mini-ETL directory on a Windows box for DataStage to access these types of files.

Thanks
Bob