DSXchange

But then it seems you already know that. :wink: Wow :) you spotted an appropriate post of mine. Looks like your version of DSXchange supplies appropriate links like those found in social networking sites ;) Yup, I was wondering if at all there was any flag in dssh that takes a file with queries wit...

To bundle the commands in a script and run them, is there any flag of dssh which accepts the script file as input and runs it ?

From inside the dssh script, is it posible to run a query and let the result dumped into a flat file using standard redirection.

Thanks

Hi, I would like to know if dssh supports a batch mode, the intention is to write a scripts which would perform below activities: 1. Add VOC entry for a hashed file 2. Delete VOC entry for hashed file 3. Create and build secondary indexes for hashed files 4. Delete secondary indexes for hashed files...

Thanks for the reply Ray, If my ignorance isn't overwhelming, Could you please elaborate on how the opcode of DS Engine is understood by the underlying processor. Guess my understanding of the below isn't correct. Ex-If there is a sort operation in a parallel job on compilation it turns up into an o...

DataStage executable code actually runs in a virtual machine (the DataStage engine) rather than needing to be linked. The codes you see in the export file are pcode instructions for that virtual machine. This seems to be like Java Virutal Machine, One more question comes to mind. When these pcode i...

Yup, its Java looking at some logos and even recollect seeing "built on eclipse" , my question was more towards which modules of Java were used and if at all any thing else other than java goes into it.

Hi,

Was curious to know on what technologies/tools is the DataStage GUI (Designer, Director, Administrator) built and on what does the client - server interaction happen.


Thanks

Oh ! My Goodness :o . The simplest mistakes are the toughest to find. Many Thanks for pointing that out and it works. Having born and brought up in the PX world, I have few dumb questions. 1. READ NDC.REC FROM FILE.VAR, ID ELSE I guess the record from FILE.VAR (hashed file) is read into a Dynamic ar...

It might make a difference if you did not copy the index(es) for the hashed file Rightly pointed, there was an Index created on the Hashed file due to which the SELECTINDEX was failing. I have created an INDEX as shown below but still the SELECTINDEX doesn't seem to work. >SETFILE /nhdb/unittest/RD...

Hi Ray Many thanks for the reply, the SELECTINDEX is used to create a record list and then a loop is defined to iterate over all records in the list to get the record whose start and end dates happen to contain input date in their range. The routine doesn't throw any error but we figured out that th...

Hi, We have a server routine which takes a date value and a key value as input and performs look up against a hashed file on the key and the input date being between Start and End dates in hashed file. The routine is running fine since an year and all of a sudden it now throws Verb "SELECTINDEX...

Change "Object type" to Object, I made a routine out of the above code and it ran fine

Hi Ray, Regarding the Standards, having once heard the rumour of Server jobs being dumped out, the admins are worried if that would be a reality one day in future so they want us to keep away from it as far as possible. There was a day in the past when all of our code was on Server edition and now w...

If you clear the entries for a particular invocation from the RT_STATUSnnn table, then the log entries for that invocation will also cease to be visible I wish there was an API for that, this keeps me wondering how to actually do it ? is it as simple as just running a delete command using the invoc...

Hi Ray, I completely agree that 250 jobs per minute is a reasonable speed but wondering if the dsjob is going to authentication and attaching to project each time we can get have a better approach with C++ API's where we authenticate only once and attach to project only once but would like to take y...