DSXchange

No, this will not work. You *cannot* write: If var = @NULL Then ... Else .... and expect anything useful to happen. Thats because @NULL represents the true "unknown value", which by definition is not equal to anything (because you dont know if it is or not). The equality test will always return @Fal...

Hi Ray, Youre right, I forgot about the other components. I know of no public API for those, Im afraid. Any such API would have to take into account the fact that those numbers are not (as far as I know) copied into the compiled job. So if you deploy a job as runtime-only, i.e. without any design ob...

Hi, Does anyone know an easy way of identifying the last row of some input data using a sequential file stage? Cheers, Dave Baumann. This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not th...

Hi ppl, I have a seq file, where for each record i have the ID, month and value ID | MONTH | VALUE 1 2002-01 100 1 2002-02 100 1 2002-03 100 1 2002-04 100 1 2002-05 100 1 2002-06 100 and i would like to transform in a horizontal record. ID | VALUE_01 | VALUE_02 | VALUE_03 | VALUE_04 | VALUE_05 | VAL...

This is a topic for an orphaned message.

Hi, Were able to load 4m records in 15 minutes. Make sure the enabled write cache option enabled in Hash file loading. You have to consider the record length as well when data is loaded into hash file. Regards Elavenil. Massi wrote: Hello, I have to compare information from two different Oracle Data...

Hello, I have to compare information from two different Oracle Data Base. The Data Base are in two different Computer (Both Unix System) and version is Oracle 8.1.6.0.0. The DataStage Server (5.1) are, instead, on Windows NT. I load some Tables of the first and the second Data Base in Hashed Files, ...

Hi Sharon, The job can be unlocked by using the following command if DS server is running in NT and I am not sure if DS server is running in UNIX. Log on to DS server by using Telnet. Use LIST.READU EVERY to get all the processes in the server & get the user no for your job and use the following com...

Hi Greg, Thanks for your explanation regarding static & dynamic hashed files. Your explanation is quite useful to understand how static & dynamic hashed files. Regards Elavenil. Greg Smallhorn wrote: The Hashed File stage (DS 5.2) has a "create file" check box. If checked, the Options>> button is en...

The Hashed File stage (DS 5.2) has a "create file" check box. If checked, the Options>> button is enabled. Clicking this button opens the hashed file sizing dialog, using which you can choose the file type and other parameters. Types 2 through 18 are static hashed (choosing one of 17 different avail...

This is a topic for an orphaned message.

With DataStage 5.2 on Unix and using DB2 as database. When using DSDB2 stage we keep having this warning being flash out about not finding the Link Eventhough the job would complete running, but we have problem as during batch jobs we are keeping an eye on the number of warnings in the batch. DSD_Ge...

Hi, Thanks for your reply. Unfortunately, I dont speak French. Regards Elavenil Kasia Lewicka wrote: I have a document about HFiles from Ascential, but it is in French - do you speak French? Kasia At 09:37 29/08/2002, you wrote: >Hi, > > > >How do i create static hashed file? and what is the differe...

OK, thats the major number. ("20" at DS 5.2). Now, how to get the other two components? ("20.0.2") I know I can get it from DS_JOBOBJECTS (ROOT record), but would prefer a more "honest" (that is, public) approach. -----Original Message----- From: len.greenwood@ascentialsoftware.com [mailto:len.green...

Saravanan, Why not contact Ascential about running a "Programming with DataStage BASIC" class in Singapore? It seems to me, from the list, that there would be demand for one. Dumping a DataStage log file into a text file is one of the many techniques covered. Regards, Ray -----Original Message----- ...