DSXchange

If a job aborts it is required eighter to reset it or compile it in order to rerun the job, why is this required, what happens when a job is reset which makes it eligible for re-run?

Yup!!!! i do know but this is the current Environment which is setup in Production......... and i don't have the authority of changing the config file, I need to find some way using the what is existing.

we are not supposed to change the config file ... the current one is a single node one.....

Hi ,
I have a huge chunk of data which i need to put into different files based on a key. which stage does this???

Primary aim is to sort the entire data but unix sort fails as the file is huge, hence devide the data into diff files and then apply trasformation then concatenate diff files.........

The code for the above routine is EQUATE RoutineName TO 'KeyMgtGetNextValueConcurrent' If NOT(Initialized) Then * Not initialised. Attempt to open the file. Initialized = 1 Open "SDKSequences" TO SeqFile Else * Open failed. Create the sequence file. EXECUTE "CREATE.FILE SDKSequences 2...

Hi,

I am trying to run the above command at Datastage administrator
the error i am getting is :

"Retrieve: Syntax error. Unexpected sentence without filename."

How can i get the count of entries in DS_JOBOJBECTS???

Thanks for the info!!!!!!!!! :D
where can i find information on how to work with universe queries????

What is @RECORD and what value it contains in the following query???? The query is SELECT DS_JOBS.NAME AS JOB_NAME, DS_JOBS.CATEGORY, DS_JOBOBJECTS.NAME AS OBJECT_NAME, DS_JOBOBJECTS.OLETYPE, EVAL DS_JOBOBJECTS."if index(@RECORD,'#prmSearchArg#',1) = 0 then '0' else 'FOUND' " as REC, EVAL ...

when i run this query in DataStage Administrator "select * from DS_JOBOBJECTS where OBJIDNO='7244' " it is not listing all columns from DS_JOBOBJECTS....

By the way for what stuff is this uvsh???? Is it only to run the queries on UV tables???

I am trying to run this at unix ==> uvsh "select * from DS_JOBS where NAME like 'djpXFMAcctArr'" but getting this error message Could not load program uvsh: Dependent module libgciudt6.so could not be loaded. Could not load module libgciudt6.so. System error: No such file or directory do i...

I am familiar with IBM DB2 database and found that the functions in DB2 doesn't work UV tables.... where can i find functions which work with UV tables??? For example: In DB2 to get only first 2 rows "fetch first 2 rows only" is used ... so what is the equivalent in UV? and to know the col...

Is there any possibility to know column names this DS_OBJECTS UV table contains using a query in DataStage Administrator???

I am trying to learn..... got across this DS_OBJECTS but did not find any documentation related to that.......
checking if someone here has got reference to any documentation regarding the same.

I am trying to learn..... got across this DS_OBJECTS but did not find any documentation related to that.......
checking if someone here has got reference to any documentation regarding the same.