DSXchange

Raftsman wrote:Both clients need to exist on your local machine.

Thanks Jim,

But we have a compnay policy to have these application to be accessed only as virtual application.

Thanks
Nitin Swarnkar

Hi, We are using datastage 7.5 client tool from virtual application, once we got installed DS 8.1 in our local machines we are not able to access 7.5 designer. Our Admin told us to use Multi Client manager to switch between. But MCM is not recognizing the 7.5 Clients. So, is there any way to switch ...

Hi, I am trying to create a seq file in a local drive (i.e C). I gave the path in seq file stage like C:\path\file.txt. The job ran fine. thanks a lot Your job runs on server and file would be created on the server only, unless you have some mechanism to ftp file to you local drive, it would be rem...

Hello, When I run my sequence in Dev Environment it's running fine. But, when I run in Test Environment sequence aborted. When I run the job individually in test, that runs successfully. Following error I am getting: Thanks. Just check what are the values for DSN,UserName,Password you have passed t...

If you don't check for return codes after each run then it runs concurrently else it runs sequentially. If you want to check the status of the job then you need to break entire logic into two scripts. First one would acts as controller, which just invoke the second routine, and in second routine yo...

sspreethi wrote: Meanwhile I decided to write the count to a temp table from within the procedure which I then read from the routine. .

If you could read table from routine then you could execute the stored procedures also.

Thanks,
Nitin Swarnkar

Word of Caution :

Your logic should have some mechanism to control the number of job instance you invoke. People have faced issued when there are too many instances invoked.

Here "Too Many" could be 25 or more.

All the best !!!!!

Thanks,
Nitin Swarnakr

If your top level sequencer is a Multi-instance job, then you can mention invocation-id with job name.

Hi, You have to make your top sequencer and all the jobs, as multi-instance. Then through shell script or Datastage routine you have to run this top level sequncer multiple times, with proper invocation ids. You can search this forum for dsjob -run commnand, if you are invoking your sequencer throug...

nilesh_kant wrote: What are phantom errors and any way to look at the error message.

The word Phantom is used to refer the background processes.

Hi, the job is getting aborted saying 'Data error'. Do we need to execute this SQL through a different stage or else. Hi, I think you can run SQL through the Universe stage, but you can also try the same through Administrator client just you have to format the SQL to make it a single line command, ...

I am getting deadlock issues when i run multiple jobs concurrently. Hi, Datstage is just another user to oracle, I mean if you can do any database activity through SQL+ client, you can do the same through datastage(keeping both Users same). So if you are facing deadlock issue, it means its a issue ...

Hello, SELECT SKU_ID FROM REF_SRS_PRODUCT_SKU WHERE SKU_ID LIKE '%?%' Check the SQL in Netezza stage, after adding the SKU_ID column and execute same on the database, outside the datastage and check if you are getting same error. If error persist then its problem with data else its a problem with d...

anbu wrote: In ODBC write a user defined sql to delete the table.

I belive, you have to define a dummy column in ODBC stage and need to Use/Handle the same in you user defined SQL, in order to pass the control from transformer stage to ODBC stage.

Thanks,
Nitin Swarnkar

nima511 wrote:Can we drop a table using a DataStage Job?
Database where the table resides is a SQL Server.

Yes but the User (With which you are connecting to database) should have sufficient privilege to drop table.

You can do that in ODBC stage as Before or after command

Thanks,
Nitin Swarnkar