DSXchange

Hi All, I've been trying to get connection from our Unix box Tru64 to Oracle 9i Database but having trouble. DataStage version is 7.0. The error message is: OCItest..Oracle_OCI_9i_0: Error while trying to retrieve text for error ORA-12154 OCItest..Oracle_OCI_9i_0.DSLink1: DSP.Open GCI $DSP.Open erro...

Adam, I don't think we can modif parameter value dynamically in job sequencer, and job sequencer doesn't allow to modif its code. So if you must modif the sequencer code, I think you could do the following. Construct your sequencer, then click on "job properties", then click on "Contr...

Many people mistake the merge stage as an appending stage but it's more than that. It serves many functions, Inner join, complete set, right outer join, left outer join, etc. these joins require a common key or more. The merge stage just takes two sequential files for input, and it's a little tricky...

Yes, you can.
Use the merger stage to merge two sequential files and output to a transformer, then use an OCI lookup to lookup for data from Oracle. The output of the transformer then can insert data into Oracle table.

Good luck.

Leon

Thanks a lot for making fun of my ID. :) :) There's a saying, 'If you think like one, you'll become one'. Anyways, thanks for your suggestions, Ray. The Cleanup Resources via Director tool does not clean up the defunct process but release active sessions. I tried this a while back. The LIST.READU do...

Thanks All in advance. I experience a problem with DataStage that is unable to clean up processes in its process table. The job was closed or got killed but the DS process table still has an entry of that process. Consequently, DS puts a lock on the job so developers can't open that job because DS u...

Hi Santosh, The problem of simple solution is 02/29/2000 + 1 = 02/29/2001 (There's no such date, just like one of the helper mentioned) you have to split the date into 3 portion, yyyy, mm, dd then use the yyyy to test for leap year by mod it by 4 and remainder is 0. If it's leap year then check the ...

I believe these count methods just work for INTERNAL hash file and NOT EXTERNAL hash file. So how do we count EXTERNAL hash file?

Thanks for your time in advance.


Leon

Have you tried #DSN# for your DSN box, #UserId# for your UserId and #PassWord# for your password. In you Job Property, create these parameters DSN, UserId, and PassWord. You also need to have DSN setup at the DataStage server. I believe it works, try it.


Leonardo

I got a very strange error DataStage Job 269 Phantom 20198 Program "JOB.1949178858.DT.1256950239.TRANS1": Line 304, Improper data type. Attempting to Cleanup after ABORT raised in stage job2Tst..XfmLogics DataStage Phantom Aborting with @ABORT.CODE = 3 I'd like to view the code to see what...

Thank you very much in advance for your help. I'd like to use parameters in the constraint of a transformer. When I put in parameters DS doesn't like it and says "expected constraint". If I hard code then it accepts. Hardcode example, compare(field1,"Bad", "L") = 0 Para...

Thank you very much for your help Craig.

I used absolute path, the permission shows it's mine. jobtesting..JobControl (@rm_Tempfiles): Executed: "rm /usrs/username/temp/tempfile1.txt /usrs/username/temp/tempfile2.txt" Reply=2 Output from command ====> usage: rm [-efirR] file ... You can see there is not much of info for me to deb...

I tried to invoke rm on Unix from datastage to clean up temp files, but it didn't work. The temp files were created on the fly using parameters. In the job sequencer, we're able to use the execute command stage. The stage requires two things, command name, and parameter. If I want to execute rm #tem...

ThanhVu,
You're right, I can't find it anywhere.
Your name is very familiar. Where are you located?

DSGuru.