DSXchange

We are having a 3 node architecture. We are creating datasets in our jobs and the job is failing due to insufficient space ##E IIS-DSEE-TFOR-00001 12:10:38(000) <input repartition(0),2> Failure during execution of operator logic. ##F IIS-DSEE-TFIO-00161 12:10:38(003) <input repartition(0),2> Fatal E...

Have you ever worked with HTML or XML tags. Actually you have to define the hierarchy structure. For e.g Customer Info/Cust Name Customer Info/Cust Name/First Name Customer Info/Cust Name/Last Name Customer Info/Cust Addr Customer Info/Cust Addr/Addr1 Customer Info/Cust Addr/Addr2 The output would b...

This is not part of your routine. It is a query to prove that ODBC.H exists in UNIVERSE.INCLUDE. What happens if you rename the routine? What happens if you make a copy of the routine? ... Apologies for misinterpreting your comments Ray. Even though I make a copy of it or I copy the code and paste ...

This is not part of your routine. It is a query to prove that ODBC.H exists in UNIVERSE.INCLUDE. What happens if you rename the routine? What happens if you make a copy of the routine? ... Apologies for misinterpreting your comments Ray. Even though I make a copy of it or I copy the code and paste ...

@ID is a column name within UNIVERSE.INCLUDE. You may need to enclose it in double quotes. Or you can use the RetrieVe query language. LIST UNIVERSE.INCLUDE WITH @ID = 'ODBC.H' ... Hi Ray, I tried adding this piece of code in my routine but still it is giving me the same error. I've checked few thi...

ODBC.H does exist in UNIVERSE.INCLUDE SELECT @ID FROM UNIVERSE.INCLUDE WHERE @ID = 'ODBC.H'; So it's not that. Is this error reproducible? Perhaps you simply lost the connection from th ... Hi Ray, Thanks a lot for your reply. The error is reproducible in the sense that only for this routine when I...

DSR_EDIT is an internal helper subroutine called, among other things, when you are editing something in the Repository. Can you edit routines in other projects successfully? Try re-booting your Data ... Yes I can edit other routines in same as well as other projects. Can it be a case that I am incl...

Hi All, I've gone through many posts in the forum and still did not find any solution for my error hence I am opening a new post. I am getting an error while executing a server Transform Function in Sequence job or while testing the function. The error is: - Error calling subroutine DSR_EDIT (Action...

Hi All, I am having a requirement where I need to design an After Job Subroutine that will be called in each job via job properties. As soon as the job has status aprt from Finished OK, the after job subroutine should be called and it should reset the job. I wrote the following code: - $INCLUDE DSIN...

@Arndw: Yes thats true hence instead of executing the Transformer in Sequential mode I am running it on Partition method as Entire and then I am constraining on @PARTITIONNUM = 0, 1, 2 or 3 (that is any one partition). In case of Entire Partition, the 30 records will be replicated across all the par...

Hi All, I am having a requirement where I need to count the number of records and do a math processing on the basis of even numbers, odd numbers etc. Now as we know that in multi node architecture the counts will always be initiated from 1 for all the partitions. But the problem is I need to do it i...

I simply replaced the ";" with Char(10) and wrote the data in Seq file ina UNIX New Line mode.

Pivot stage is part of default DataStage installation. Btw, do you want the last column alone or all other columns with the last one made single? ... Hi, I needed only the last column... Here I meant that in DS 8.1 there is Pivot enterprise stage where as in Server or 8.0 there is Pivot stage that ...

Hi, I have a requirement where in one column I am getting certain values for different records. I have to extract this column and convert the values into rows. For e.g My record is as: - AD|BANK OPS|255068|1098765|BC|46E;654;87R Here the last column has multiple values seperated by ";". Wh...

How about using Field function as its UNIX box.....

Well need to check if 7x supports it.