DSXchange

Thanks for your reply. I just discovered.

Regards,
Aart

Hi,

Thanks for your quick reply. While searching for some help on DSjob I came across "varList = DSGetJobInfo( hJob1, DSJ.PARAMLIST )" (within basic.pdf, so didn't look or search to well). This gives me exactly what I've been looking for.

Thanks again and regards,
Aart

Hi all,

I wondered if it's possible, given a jobname, to get the list of parameters it expects. I found nothing to do so when searching the forums or the basic.pdf file.

Thanks an regards,
Aart Onkenhout
DLM
The Netherlands

Thanks for your suggestion Kenneth. You might have a point there. The idea is the job is going to run once a day. After processing the files I thought of creating a new directory (based on the date), copy the files into it to preserve them and delete them from the original directory. But I will thin...

Of course I can take care of the fact a directory contains no spaces, but as the directory to process is delivered to the job as an input parameter, the one that runs the job can choose any directory he or she wants to. So, I thought it should be nice to make it possible to use such directories. But...

Hi all, I wondered if there's a way to use the OPENPATH function when the directoryname contains spaces. I'm using a piece of code I found on this forum to read through all files within a directory. Works perfectly well when the directoryname doesn't contain spaces. The code I'm using looks like thi...

Thanks for the replies. For the moment I'm gonna use the variables variant Siva suggested.

Aart

Hi, I like to dynamically create a name for the outputfile for a sequential file stage. The form must be like "d:\datastage\output\file_YYYYMMDD.csv" where YYYYMMDD has to be the current date. How can I accomplish this? I tried with a user defined routine, but that's not working (either be...

When running jobs on our Windows NT machine the Windows application log is filled with Datastage messages: "Datastage error: Unable to read initial package - 81022". Although the jobs finish normally (it seems) I wonder what these messages are about. I can't find anything about it in the d...

Hi, I modified a job that wasn't very maintainable. I decided to put parts in local containers and link the output of these containers to one Sybase plugin stage. The problem is I'm getting deadlocks because the containers are executed at the same time. Is there a way to make the containers execute ...

Thanks for your reaction. In the meantime I figured a way out to do the renaming. By deleting and appending new columns (by using the context menu on a table) I don't get error messages anymore.

Thanks anyway,
Aart

Hi, Because some columnnames were changed I have to modify a couple of datastage jobs. Seems like a small job to do, however, with DS 3.5 it isn't. Whatever I try, I just can't rename a column (well, I can, but after that compiler errors are given). Removing the column and adding with the new name d...

Hi, I'm using Datastage Designer 3.5 to move data between two Sybase 11.5 servers. One of my columns is of type text. When importing the table with this datatype, datastage makes it a longvarchar. However, when compiling the job, I get an error stating the datatype isn't supported. Is there a way to...