DSXchange

Hi, All my jobs in one project disappear. I search the dsxchange knowlege base. I found this command: DS.REINDEX ALL. My question is: 1> where I can I run this command, is it from Datastage administration tools? or can I be run in more than one place? 2> Can I specify just a particular project name?...

Hello,

Currently I am in DS 7.5.2. What are new features in DS 8.0?

Can someone give some input?

**Note: Subject changed to be more descriptive - Content Editor **

Hi,

Has anyone work with CLOB data type in Datastage?
Does datastage support CLOB data type?

Thanks,
Hoa

Hi Craig, I did it for a test to see scheduled jobs. I scheduled a job to run in the next five or ten minutes and run it today in datastage director, I am using datastage job scheduler, not Unix crontab. Usually after I scheduled, I should see it in datastage director so I know that the job has been...

Hi Craig,

We have an operational login id for all ETL jobs. I logged in with the operational login and scheduled a job to run in the next five minutes and I should see the job I just scheduled it but I don't see and the job did run at the scheduled time.

HN

Hi Craig,

I did for a test. I logged on myself and scheduled the job so I should see it but I don't. Then the job ran at the specified time.

HN

Hi, I schedule a job in datastage scheduler but it's not showing the job has been scheduled in director. However, the job does run at specified time. Since I do not see them I would not be able to tell how many jobs have been scheduled or to unschedule them. In director, under view, does have a chec...

VCInDSX,

I do not know what to say but you guys are awsome!
I am pretty sure more questions to come...

Thanks,
HN

Hi Gateleys,

I just now see it...I will disect through the sample job and see how much I can understand and be able to build the job myself.

Thanks,
HN

Thanks for your response....

However, If you can send/point me to a sample code, it would make it very easy for me to learn.
Thanks in advance,
HN

Hi,

I'm very new to XML datastage. Could someone send me a XML sample code that pulling data from a database table and output to a XML_Output stage?

Thank you very much,
HN

Yes, What is it? lie=false. So ODBC does allow to lie if set to true. lie what?

Yes, But oracle never produces any log when runs job with oracle stage. Below is a snap shot of Netezza .odbc configuration which I did not cut/past further enough to cover this part. [edwprod] Driver = /usr/local/nz/lib/libnzsqlodbc3.so Description = NetezzaSQL ODBC Servername = edwprod Port = 5480...

Hi Ray, No, we do not have any temporay directory setting for logs. Below is a snap shot of my .odbc.ini: [rdwpre] Driver=/u01/Ascential/DataStage/branded_odbc/lib/VMor820.so Description=DataDirect Oracle Wire Protocol ApplicationUsingThreads=1 ArraySize=60000 CachedCursorLimit=32 CachedDescLimit=0 ...

Hi, Currently my job with netezza stage produces its log files at /tmp where it has very limited space. I like to have those log files produce in the location other than /tmp when the job runs. I go in to uvconfig file change the UVTEMP parameter setting to a new location, then shut down datastage a...