DSXchange

The code for SEEK is as follows Thanks xcb and mhester

Prashant

Yes xcb the file does get created. It was code Arnd helped me out with. Also thank you all for your help. I got it to work.

I have an existing sequential file that was generated by an earlier DS job - joblog.txt in the below example. Now In my job Control code for a set of different jobs I need to add a few more lines to this file. But I seem to be overwrting whats already existing in that file. I have attached my code b...

Hey Arnd, Thanks a lot for your response. The after job routine works, though how do I pass the value for rowcount to the routine. FOr example I got the value for rowcount from the previous job and passed it on to a job parameter called ROWS in the current job. Now this I want to write to the sequen...

Hi I am trying to generate a report at the end of a DatatStage job. I have all the values I need. My report should look like : DAtA QUALITY ANALYSIS FOR $ TABLE No of rows extracted from Source - $ ROWCOUNT N o of rows extracted from Targett -$ ROWCOUNTTGT No of rows that do not match - $MISMATCH KE...

Now the look ups were against Universe databases and I changed all that to the DRS stages and it now runs in 5 min. I split the look-ups over a couple of more transformers, turned on the inter-process buffering, increased the read write cache size for the Hashed Files to 999 MB, tried playing around...

Hello I have a huge job that has performance issues. It takes 1 hr 25 min to move data across for 2100 rows! The size of the data is not too huge however there are 2 transformers directly connected with over 20 look ups each to universe stages. The resaon for universe stages is beacuse the has files...

Hey Ray, I'm not too sure I understood you very clearly.I'm not very familiar with DS Basic.I right now do have to add a new DSN for each load and I really dont like that.Can I in some way create a DSN on the fly based on what you were saying?We dont need the DSN after the load is complete. I was lo...

Hey Ray
It actually is a very strange way to run a IT shop.The business demands it though.They are in the legal doucment services.SO the number of databases created is arbitrary even though the tables created in this database may have the same metadata most of the time.

regards
Prashant

The table definitons do change sometimes.But If we assume them to be constant the database changes everytime.So there is a different database for every load even though the table in the database may be the same.So I have to point to a different database each time right?This I need to specify in my D...

Its not about passing the parameter to the job...which in any case is already been defined.Its creating a new DSN to point to that particular
server.database.tablename each time the parameters change.

Hi, I have developed jobs using DataStage to replicate a Data Transfer process.The problem I face is that for every transfer there is a new DataBase which means that I have to create a new DSN Every time to import my table definitions .For example these are my source definitions: Load01 Server: PSSQ...

When I used the modified code it worked in the morning.Now when I try to run it, it gives me a " Failed to compile test harness error".Do you have any clue as to what that means. Also in the morning it wasnt reading files stored on an other server.I mean it used to open files on the Ascent...

Ray, I did not completely understand your code. But I tried using it and compiling it and it gave me the following: WARNING: Variable 'FINFO$IS.FILEVAR' never assigned a value. Compilation Complete. openseq Arg1 to testfile Then Ans = 0 Else Ans = 1 closeseq testfile is what I wrote and it works for...

The Basic Manual says not to use this as a transform but basically I need to check this for 60,000 rows. The file path is a column in my Sql server table. So if i write a routine and call it before my transformer stage executes I need to write the ones that do not exist to a sequential file and not ...