DSXchange

In pseudocode..... If you find that 'n'th char is where you need to break, do it like keyField = keyField nonKeyField = nonKeyField[1, n - 1] : newlineChar : nonKeyField[n + 1, 9999] I will leave it to you to derive the value of 'n' and 'newlineChar' Need help to define the 'newlineChar' , if I giv...

Have a shell script and a multi instance job, read the file name and invoke a instance of the job using dsjob command once your shell script reads the control file ..exit script...

Hi Ernie,

That worked like a charm , although instead of using two counters , I did a mod (@INROWNUM,500) = 0 then count +1 else count , to keep track of every 500 rows.. Thanks again Ernie..

Thanks a lot Ray..

I tried this :
FUNCTION DELAY(Arg1)
SLEEP Arg1
PRINT 'STARTING DELAY'
EXECUTE 'CS'
PRINT 'DELAY COMPLETE'
Ans = 1

and it worked, but yours is much more understandable, I will do it your way..

Where can I use the sleep command , i dont see it in the transformer.., I have not created a routine , can you please help me.

For example, if the number of rows has reached 500 , create a 2 minute delay and then start processing the next set of 500 and then a 2 minute delay and so on..

I want to send rows to a Web Service transformer in a controlled format , is there a sleep functionality in DataStage Server Jobs...

Hi All, I am loading data into IBM Maximo via web services transformer using WSDL call. In the current design if there are 100 records , it makes 100 calls to Web service and there by belting the server 100 times. (100 is just an example , records go as high as 2 million). So in those cases its real...

http://picasaweb.google.com/dganeshm/DS#5434456807639732514 I want the header in a separate columns and the content in the separate column ,here the header is non repeating but the content is repeating, I am not sure how to do it in separate columns , I am able to do it in a single column comprisin...

Two ways :

Change the precision of the decimal to n,3
Treat as a string , do a substring from 1 to index of 1st occurence of '.' + 3.

AviETL wrote:On windows server there is no odbc.ini file. DataStage should pick up ODBC DSNs from windows registry

Oops !!! I conveniently ignored that....

I have installed IBM Information Server (8.1) on Windows server. SQL server ODBC DSN created through windows ODBC setup. uvodbc.config in project directory modified with appripriate entry. But when I tried to import metadata using ODBC it gives error as "Empty DSN: list returned from host <ser...

chulett wrote:So, what was the resolution?

Yeah, it would be good to know the resolution..

I agree. I re-ran the job after changing login information and the job aborted with a different error message, bad username and password exception. the server which is hosting the webservices itself is not up and running. whom do i contact to find out the server is not running. Thanks Mark If you k...