DSXchange

Hello to all DS-Users, we have a lot of jobs which are stored in a version manager (PVCS) as *.dsx files. Now after a file have been checked out were looking for a way to compile and release this job outside from the Datastage-Manager. I know i can do this with a telnet session but were looking for ...

Thanks Tony, I am now trying the parameter approach. This should work - I will test it soon. Dirk -----Original Message----- From: Tony Curcio [mailto:tonycurcio@yahoo.com] Sent: Thursday, October 25, 2001 3:41 PM To: datastage-users@oliver.com Subject: Re: Using variables Are you defining the varia...

I got one idea from someone I just phoned. He says that for variables to be available in an input stage, it must be passed to the job as a parameter. Variables cannot be calculated in an input stage. I will have to run a control job which will calculate the parameter, and then pass it to the next jo...

Are you defining the variables once per job (ie. they get set at the outset of the job and remain persistant)? If so, you will want to pass these in as parameters (go to the Edit / Job Properties menu and click on the parameters tab). Once you create the parameter, you can refer to it in your sql by...

You should ALWAYS use the -server -userid -password command line options. This is known to tech support and that will be their recommendations. Based on how clients can setup security, these options may be unnecessary, but your conditions must REQUIRE these options. Your problem will go away. Good l...

Hi, I have to use variables in one of my INPUT stages. Data will be selected according to 2 variables select * from product where company = variable_1 and client = variable_2 ..... but variable_1 & variable_2 still has to get values, so I tried (user defined sql, using a user defined routine) select...

On 11 Aug 2000 I posted code to do this task on this list. It should be in the archives. If you cant find it there, I can email it to you off line. The technique is also taught on "Programming with DataStage BASIC". Enrol, or join a waiting list, today! -----Original Message----- From: William Tan [...

Thanks Chris, No One had touched the uvodbc.config. But that lead us to the problem. For some reason yet to be determined DNS resolution had been changed. To cut a long story short when we changed host = localhost TO host = 127.0.0.1 It all worked again. Thanks Jack ----- Original Message ----- From...

Ray, thanks for the detailed explanation. What Im trying to achieved is to extract the logs into a text file. After asking the local Ascential engineer, his suggestion was to issue the following command at the Unix prompt (at the project directory): binuv "" > The above command works. But I noticed ...

Weve been able to run the CLI successfully without passing the login clause as it picks up the user invoking the command. However when we redirect standard input, standard output and standard error as below, it cannot access the current user. It returns an 80011 error - incorrect system name, user o...

There is no command, per se, at the UniVerse prompt for accomplishing this. UniVerses "unload" is called UNLOAD.FILE.B, but it is not catalogued as a command. So there is a two step operation. CATALOG APP.PROGS UNLOAD.FILE UNLOAD.FILE.B LOCAL UNLOAD.FILE RT_LOGnn pathname where RT_LOGnn is the job l...

Hi,

Im trying to extract tsome DataStage job logs into text files under
the HP-UX. Does anyone know the command to do such a thing at the
Universe prompt?

Thanks.

Regards,
William Tan
--------------------

It will depend on the database of course, but why cant you do exactly what youd do working directly with the database? For example SELECT SEQ001.CURRVAL FROM TABLE; -----Original Message----- From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt] Sent: Thursday, 25 October 2001 01:37 To: LIST-DataStage (E-...

If you really need to do this, then you will have to call ODBC direct from UniVerse Basic. Refer to the UniVerse BASIC SQL Client Interface Guige (BCI.pdf), for details of how to do this. Have you considered just using a lookup? The user defined query (in the case of Oracle) be something like select...

Are you using the same DB2 stage for the lookup and for the insert? DataStage uses the links to sort out sequencing. Inputs to a static stage (your insert) will be processed before outputs from the same static stage (your lookup). If this is the case in your job, you need to use separate DB2 stages....