DSXchange

Oh.. I didn't mention that it's a Teradata that we are connecting to.. sorry! I did try to ping the database from unix and it doesn't get resolved. And i looked up into /etc/hosts and i couldn't find any entries for the server in it. Will that be a problem ? If i add entry in to hosts file, will Dat...

thanks Ray. Here it is.. $INCLUDE DSINCLUDE DSD_STAGE.H $INCLUDE DSINCLUDE JOBCONTROL.H $INCLUDE DSINCLUDE DSD.H $INCLUDE DSINCLUDE DSD_RTSTATUS.H Equ SetParams To 'SetDSParamsFromFile' ErrorCode = 0 ; * set this to non-zero to stop the stage/job JobName = Field(STAGECOM.NAME,'.',1,2) ParamList = ST...

Amigos, I have a strange issue with one of the projects on a datastage server which hosts mutiple other projects. All the other projects are using the TNS name to connect to the database, while the project 'X' under concern uses IP as the jobs inside it could not resolve the TNS into IP's. The only ...

kduke wrote:99 means job is compiled. There is no start or end time on a just compiled job. ...

Exactly.. @Venkat: You are trying to get the timings of a multiple instance. So the start time is the when the job is last compiled and end time probably one of the instance which has finished recently.

Is it a multiple instance job by any chance?? I have seen this happening a few times only to find that it was multiple instance job.

You should be able to clear any locks on the job by logging into UV with 'dsadm'. Please follow the below steps. 1. Go to DSEngine directory 2. Execute .dsenv 3. Execute bin/uvsh, this will log in to UV. 4. Type list.readu and find the user id for the job in question 5. type "unlock user userid...

Any replies/ideas gents :D ?

Hi, The issue is regarding the datastage parallel jobs not failing despite reporting fatal errors after the fast load. The job has finished writing orchestrate load summary but the end loading and collect stats issued by datastage has failed because "Too many END TRANSACTION statements". A...

I would go for join option and also would first extract the reference data in datasets in separate jobs. I would strongly recommend join option if the volume is high. Look ups should be carefully used in the design, otherwise it could be a nightmare to support when the volume goes up fro reason in ...

use APT_DISABLE_COMBINATION parameter and set it to true in your job.

ouch! sorry abt that!!!

Thanks a lot! I suppose 10 mins is a bit too much for my requirement.
The testing would really come up screaming at me! Thanks anyway!

Thank you!

Hi, I have a problem in achieving the following XML output.Please help me out with this! Input : 3 columns ID1 ID2 ID3 45 52 87 Marked in red are Hard-coded columns. Output : <TCRMOrganizationBObj> <TCRMOrganizationNameBObj> <OrganizationName> Corporate Markets </OrganizationName> </TCRMOrganization...

It d same here too!

In ADMN client it working.. but not in dssh..

btw.. can somebody tell me as how to list all the tables in Datastage SQL prompt??? i.e in dssh...