Search found 22 matches
- Tue Mar 15, 2011 4:57 am
- Forum: General
- Topic: DSParams routine & TNS name
- Replies: 5
- Views: 5006
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...
- Fri Mar 11, 2011 4:54 am
- Forum: General
- Topic: DSParams routine & TNS name
- Replies: 5
- Views: 5006
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...
- Fri Mar 11, 2011 4:26 am
- Forum: General
- Topic: DSParams routine & TNS name
- Replies: 5
- Views: 5006
DSParams routine & TNS name
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 ...
- Fri Feb 11, 2011 5:08 am
- Forum: General
- Topic: how to get correct value of job end time using dsjob comamnd
- Replies: 6
- Views: 5624
- Thu Feb 10, 2011 7:00 am
- Forum: General
- Topic: how to get correct value of job end time using dsjob comamnd
- Replies: 6
- Views: 5624
- Thu Feb 10, 2011 5:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage job still in "Running" state -- after us
- Replies: 3
- Views: 5261
- Thu Oct 28, 2010 1:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Teradata End loading command issue
- Replies: 2
- Views: 3396
- Mon Oct 25, 2010 4:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Teradata End loading command issue
- Replies: 2
- Views: 3396
Teradata End loading command issue
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...
- Fri Oct 08, 2010 4:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Complex lookup against huge data
- Replies: 4
- Views: 3617
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 ...
- Thu Mar 18, 2010 3:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SIGSEGV Issue Using Lookup Stage for Range Lookup
- Replies: 4
- Views: 3378
- Wed Dec 17, 2008 10:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Output stage! Help needed...
- Replies: 9
- Views: 3418
Hmm!
ouch! sorry abt that!!!
- Wed Dec 17, 2008 4:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Output stage! Help needed...
- Replies: 9
- Views: 3418
Yeah!
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!
The testing would really come up screaming at me! Thanks anyway!
- Tue Dec 16, 2008 10:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Output stage! Help needed...
- Replies: 9
- Views: 3418
Thanks!
Thank you!
- Tue Dec 16, 2008 12:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Output stage! Help needed...
- Replies: 9
- Views: 3418
XML Output stage! Help needed...
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...
- Fri Dec 12, 2008 6:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: List of all Px Stages
- Replies: 8
- Views: 3168
yeah!
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...
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...