DSXchange

Hi all of you Guys,
Thanks for your response. The logic that MANTEENA has specified is working but we need to keep the transaction size to 1.
Thanks very much for your help.

HI ArndW,
I have to make the job abort if 50 rows are written to the error table which is there in the job. my options are to call DSLOGFATAL function in the constraints and make the job abort after 50 rows.Is DSLOGFATAL function ok to use.
Thanks

Hi guys,
I Have a table and i want the job to abort if i get 50 rows in it. Can any one help me out with this.
Thanks

craig and ray,
Thanks for your reply. Ray you are right the problem was with the database stage it is coming from.
Thanks once again

Hi all,
I am getting an error while running a job which was running earlier. the error says that unable to read the row. x[-100].
this is occuring at the transformer stage.
Thanks

Hi Kenneth,
i also tried to do re-indexing it is giving error messages. May be i may have to Re-install the datastage engine.
Anyways Thank you very much for your time.

Hi kenneth,
I am unable to open the other project too. Iam getting the following error when i was trying to open the other project.
CANNOT OPEN FILE UV_USERS STATUS = -2.
Thanks

Hi kenneth,
The project was running till yesterday. My manager was doing some job and suddenly when he logged out and tried to log back in he got the error i gave. We dont have any back-ups so do you have any suggestions for us to get the jobs we have recently developed.
Thanks.

Hi guys,
when i was trying to login to the datastage project. iam getting the following error.
ERROR CALLING SUBROUTINE :DSR_NLS. CHECK DATASTAGE IS SETUP CORRECTLY IN PROJECT DWPROD.
(UNABLE TO LOAD SUBROUTINE ON HOST(30115)).
any help would be appreciated.
Thanks

Hi ,
I am getting a peculiar problem when iam opening a job. Befor i Open the job iam getting MyCreateObject :- Trying to creat object with Null OLE Type. I am unable to view the properties dialog box of any stage.
Any help would be appreciated.
Thanks

Thanks Ken,
I got it. This time i want to thank you correctly.
Ravi

Hi,
I want to add some more details to my question. With this routine i am trying to exucute jobs which have the same names as the flat files i get which are strored in the file list.
Any help would be appreciated,
Thanks

Hello all, I am trying to run a routine which loads data from sequential files into the staging area. there are several jobs which load the data from sequential files to staging area. i get different files from different sites. the routine that i have written is $include DSINCLUDE JOBCONTROL.H SiteL...

thank you ray wurold, actually i was asking about the orchestrator operator in an oracle stage which is accessed by a look up stage. In one the parallel jobs i have seen that we use orchestrate.column name in the predicate clause of the oracle stage to refer to the other link that is going to the lo...

HOW IS ORCHESTRATE USED IN THE DATABASE STAGE WHICH IS USED AS A REFERENCE TABLE FOR A LOOKUP.COULD YOU PLZ HELP ME OUT WITH THIS.I COULD NOT NOT UNDERSTAND AS TO WHETHER WE HAVE TO USE A JOB PARAMETER.