DSXchange

Oki, that is the question. And if i have a parameter = "TableA TableB" its possible to create a new parameter where the default value is the result of a routine using ? For example: parTA where default value is GetTable(#parTables#,1) parTB where default value is GetTable(#parTables#,2) Thanks again...

Nuno, Let me see if I am understanding you correctly. Are you asking if two stages within a single job can use two different list values? If so, DataStage passes a single value to a job for each specified run-time parameter. Thus it is not possible to have a parameter represent one list value in sta...

Hi all, If have a List parameter with two values: *tableA *tableB Its possible to use in datastage components the list elements? For example its possible to use in a component(for example an ORAOCI) the first list element, and the second list element in another component? Thanks all, Nuno Pimenta

Hi Nuno, But yes you use each parameters in OCI Stages, ODBC, UV, .... best regards Rui Soares Rui Miguel Soares NOVABASE - Business Intelligence Mail : Rui.Soares@Novabase.PT Tel (NB) : 351 21 383 65 92 Tlm : 351 96 347 08 40 -----Original Message----- From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt...

For versions 5.X+ on Unix: cd `cat /.dshome` . ./dsenv bin/uvsh To "connect" to a specific project, type in: >LOGTO projectnamecasespecific To exit back to unix, type in: >Q For versions 4.X- on Unix: cd `cat /.uvhome` . ./dsenv bin/uvsh To "connect" to a specific project, type in: >LOGTO projectnam...

The dsenv file does not live in the bin directory, but should be one level up. Depending on your version and where you installed DataStage, it could be in a couple of different places (typically). My install goes back to 3.1 and the uv directory is where the file exists for me. Thats why the instruc...

Hi Craig, Which directory do you want me to fire it in. I am currently getting "./dsenv: not found" error, when I run it in Datastage bin directory. And what do you mean by "make sure your environment is similar to the server" .. will an entry in the PATH variable suffice ? Any pointers to any docum...

We are using 5.2. I intend to use the "Universe" commands only, not the database part. Thanks Rk ----- Original Message ----- From: "Wurlod, Ray (BSG)" Date: Mon, 9 Sep 2002 07:31:31 +1000 To: Subject: RE: uv sh in unix > What version of DataStage are you using? (This affects the name of > the execu...

What version of DataStage are you using? (This affects the name of the executable you would need to invoke.) I would read your DataStage licensing agreement fairly carefully too; DataStage is not intended to provide you with a free copy of the UniVerse system to use as a database (particularly now t...

Im pretty sure all you need to do is source the dsenv file (ie, make sure your environment is similar to the server) and then execute the uvsh command. For example, my server is installed in "/datastage/Ardent" so I would... cd /datastage/Ardent/uv . ./dsenv (note that is: dot space dot slash dsenv)...

I am tryin to get to use the universe commands through the Unix prompt .. Can someone outline the steps I need to take so as to be able to invoke the uvsh client inside the unix telnet ? Thanks rk -- __________________________________________________________ Sign-up for your own FREE Personalized E-...

Hi Doris, This functionality is built into version 5.1 and is really easy to use. So you may just want to get an upgrade. Regards Adele McClue -----Original Message----- From: Phaneender Aedla [mailto:phaneender_aedla@mindtree.com] Sent: 06 September 2002 06:17 To: datastage-users@oliver.com Subject...

Ray, Ive already look through the odbc.h file, but definitions are not always clear for me - Im not a native English speaker. So thanks for valuable advices! About your last remark - sure it could be done in a job, but my program is more complex and a a routine seems more suitable, but perhaps I wil...

Among the several options in the SQLFreeStmt command, using SQL.Close will be sufficient (the result of the first statement will be available to the second)? kasia At 23:18 05/09/2002, you wrote: >Basically you need to free the Statement environment before you can >execute the second statement. Chec...

Mind you, you could have created a DataStage job to do exactly this task! -----Original Message----- From: Wurlod, Ray (BSG) Sent: Friday, 6 September 2002 4:30 PM To: datastage-users@oliver.com Subject: RE: Some questions about SQL Client Interface Heres an extract from the output of HELP BCI SQLFr...