DSXchange

Hi,

Before you go any further I suggest that you go through the server documentation available.

As far as parameters is concerned, pls check coredevgde.pdf page no 160. It gives info on how to set parameters for server jobs.

HTH
Rich

Hi,

You can use the following calls in your job control to set the parameters at run-time.

DSSetParam (hjob, "DSN", "DSN value")
DSSetParam (hjob, "UID", "UID value")
DSSetParam (hjob, "PWD", "PWD value")

HTH
Rich

Hi, You dont have to bug Ascential for orchestrate documents. We had a discussion on this few days back and one of the posts provided a link which connects directly to Ascential website for orchestrate docs. Here it is. http://ascential.com/eservice/pages/products/manuals/orchestrate.html HTH Rich

Hi Thiagol,

How about using runtime column propagation. The runtime column propagation can be enabled using Datastage Administrator and since you are using a sequential file you need a schema file.

HTH
Rich

Hi, dsxuserri - Thanks for the info. resource disk "/opt/apps/Ascential/DataStage/Datasets" {pools "DS" "LFS" "FS" ""} I was unsure becuase your node number was a 4 digit number. Can you please double check if you have node3671 in one of our config f...

Hi Ray,

Ray wrote:I am not certain what exporting and importing with overwriting will do to the job number. I've never bothered to look.

FYI

Exporting and importing with overwriting option does give a new job number. I just checked.

Rich

Hi Sun,

Why not union a dummy row to the container output in which case you will have atleast one row and your job will not run infinitely.

HTH
Rich

Hi Sudarshan, I think you have created the hash file using directory option and that is the reason you are getting table not found exception. You can use the account option for creating hash file in which case you will be able to access the same hash file using UV stage. If you still want to persist...

Hi,

I have seen a similar kind of error during runtime and a force compile fixed the problem.

Did you do any upgrade or plug-in installation?

HTH
Rich

Hi, Sai & dsxuserrio - Thanks for the response. I have already done what you both have suggested. I manually deleted the control file(.fs) and the data files associated with it. But my problem is that I would like to do it in a sequencer using ExecSH routine and using orchadmin delete command. T...

Hi, dsxuserrio - Thanks for the reply. The job creates both a dataset as well as a fileset. I did use orchadmin delete from the unix command line for both the dataset and fileset. These are the results. For dataset ##I TUTL 000031 06:14:44(001) <main_program> The open files limit is 2000; raising to...

Hi,

You can have different uvodbc.config for different projects. Are you checking the right project directory?

Moreover, whatever is defined at project level overrides that given at dshome level.

HTH
--Rich

Hi All, I have used the Dataset Management Tool to delete datasets and filesets. If I have to do it in a job I have been using routine stage in a sequencer and calling orchadmin delete command to delete the datasets. I was wondering the Dataset Management Tool under the covers was using orchadmin de...

Hi,

We had the same problem some time back. Pls search the PX forum. We also posted the solution we got from Ascential Developernet.

It has something to do with directory permissions.

Here is the link

HTH
--Rich

Hi Vishvas, What is the client tool that you are using for Teradata. Is it Teradata SQL Assistant. Are you able to view the Data using Teradata SQL Assistant. When you try to view the data from the Teradata API stage what is the error message that you are getting? I have used the Teradata API stage ...