DSXchange

This is a topic for an orphaned message.

Another easy way to do this is to use the aggregator stage such that you zero fill columns that you do not have the actual data for in the upstream transformer stage passing the rows down to a aggregator stage grouping all the respective none pivoted columns and doing a max on the pivoted columns. T...

We are tunning our processes, and we are changing three OCI parameters.

Can anyone tell me the meaning of:

*Array Size
*Transaction size
*Rows per Transaction

and the relationship between them.

Thanks again.

Nuno Pimenta

This is a topic for an orphaned message.

Thanks a lot, I hope it will be OK Laurent "This e-mail message is intended only for the use of the named recipient(s). The information contained therein may be confidential or privileged, and its disclosure or reproduction is strictly prohibited. If you are not the named recipient, please return it...

Hi,

Whats the binary value of Link.NOTFOUND? 1 or 0?

Im using that variable in one constraint, but seems like it returns 0 when the lookup link found no records.

Thanks.

Nuno Pimenta

Hi Nuno, To the bext of my knowledge, you need to pass the parameter twice. I dont have informix but i tried it the following with ODBC connecting to Access database. I guess it would work with InfmxCli too. I set the query property to user defined query and the query was: SELECT fieldA1, fieldA2 FR...

Hi all,

Im using a InfmxCli and i execute the follow query:

SELECT fieldA2 FROM TABA where fieldA1=? and data = (SELECT max(data) from TABA where fieldA1=?)

The ? identifies a parameter. How can i do, if in the query i want to use the same parameter twice?

Thanks all!

Nuno Pimenta

This is a topic for an orphaned message.

There is a PDF file on the DataStage CD which explains this stage. laurent.loquet@valeo.com wrote: Im trying to use the Pivot stage but I dont understand how it works. Theres nothing explained in the help. If someone can help me... (how to use the derivation for example...) Thanks Laurent "This e-ma...

Im trying to use the Pivot stage but I dont understand how it works. Theres nothing explained in the help. If someone can help me... (how to use the derivation for example...) Thanks Laurent "This e-mail message is intended only for the use of the named recipient(s). The information contained therei...

Cant guarantee that this would help with your problem, but we run on Tru64 as well and the latest version is 4.2.1r8. I would suggest upgrading before beating your head against the wall too much longer as there are quite a number of fixes and changes between your version and the latest one. -craig "...

Thanks for the reply , the sleep command after the reset solved the problem best regards luc -----Original Message----- From: DataStage Developer [mailto:datastagedeveloper@hotmail.com] Sent: Saturday, December 15, 2001 2:49 PM To: datastage-users@oliver.com Subject: Re: resetting and rerunning a jo...

Hi Ray, thank you for your replay, but i have just tried your suggestion but DBMSCODE link variable doesnt work. I have a null value into the sequential file. Im working with DS 4.1.1r2 on Compaq True64 and id like to handle the DBMS return code (i.e.: ORA-00001). Every suggestion will be welcome. T...

The DS_JOBS table has a column called READONLY. If its value is NRO the job can be edited. If its value is RO, the job is read only. To make the job read only: UPDATE DS_JOBS SET READONLY = RO WHERE NAME = MyJobName; Beware that the SQL is case sensitive, and dont forget the WHERE __________________...