DSXchange

Hi forumers.... I have a problem and I don't know what's going on. When I compile this code (this is a routine called TraeConstante), I get the following messages: WARNING: Variable-> 'FileConstante' is substituted for-> 'xPath' on line-> '17' If an input link column variable is used for this argume...

Ken:

Thank you. This works perfectly well :D .

Thanks to this forum; it saved my work.

Bye.

Hola mis amigos.... :D

I need to access a hash file from within a BASIC program. The key of the hash file is composed by several fields.

What is the BASIC sentence to write in the program, to read a record given all the fields of the key ?

Thanks in advance.

Hi forumers.....

I am sending notes from within DataStage using DSSENDMAIL function.

I couldn't send a note copying to more than one users.

Does anybody know how can I do this ?

Thanks in advance, and everyone have a nice weekend.

:D

Hi, forumers.

I need to know how can I get the day of the week, using some function.

I read the ICONV and OCONV functions but I couldn't get how to use it.

Does anyone know this ?

Thanks in advance.

Ken:

Thanks for your answer.

Here is a cut&paste of what I am doing.

...........

The idea here is to filter the job by those parameters, where the CLASETAR column of the input file may contain a value equal to ClaseTarketa*. Is this clear ?

Thanks again.

Hi. I have a huge problem when I filter an input file, using a transformer stage :cry: The input file has 24000 records, and from these records about 16000 match the selection criteria. But only 9500 are selected (all numbers were rounded). Is there any limit in DataStage for the process of records,...

Craig:

Thank you for your answer, but I didn't find any information on the manuals (*.pdf) that I have installed in my PC.

Could you send me the PDF containing this information ? My e-mail is gbarsky@osde.com.ar.

Thanks in advance.

Hi there.

I would like to know how can I use a PIVOT stage. I didn't find any information on the help manuals.

Thanks in advance :D

Ray, Ken, Kim:

And the million question is: what is the implementation of "pipes" in Windows 2000, and DataStage 5.2 ?

Thanks in advance.


Guillermo P. Barsky
Buenos Aires - Argentina

Ken: Thanks for your answer. I already worked with queues in AS/400, with a FIFO (First In First Out) implementation. When I wanted to read from a queue, I had a parameter to say the time to wait; if this parameter is -1, then the program will wait doing nothing until any data appears in the queue. ...

Kim:

Thank you.

As far as I understood, a named pipe is like a seq. file: one process writing the file, and other process reading it. What is the difference ?

Is a named pipe like a queue ? And how do you use it ? And how would you use a seq. file ?


Guillermo P. Barsky
Buenos Aires - Argentina

Kim:

Could you specify me where did you post the code for checking the length of a sequential file ?

Thanks.


Guillermo P. Barsky
Buenos Aires - Argentina

Hi. In the seq. file stage, there is a check box called "Stage uses named pipes". What does this check really mean ? Is the behavior of the file like a queue with FIFO and LIFO options ? How does it work ? I need to know this because in collaborative process this is very important. And I d...

Kim: This is the invocation that I am executing, from within the .bat file: E:ascentialdatastageenginebindsjob -run -mode NORMAL -param pmMandante="221" -param pmHost="10.250.0.20" -param pmDriveEjecucion="E:" -param pmPathBase="AscentialDataStagePublicoOSDE" ...