DSXchange

Seems to be all files. I've tried about 4 different txt files. One was just a 2 column, 2 row comma delimited file. I get the same error each time. I might add that after I get the error I previously mentioned, I get a data browser box informing me that "There is more output available for the e...

Yes, the format matches exactly.

We are new to parallel jobs, so I'm not sure if there is any setup work that we need to do.

I am trying to view data from a sequential file stage in a parallel file. I get the following error: ##E IIS-DSEE-TCOS-00037 13:55:17(007) <main_program> Failed to open performance file False/performance.5460; I know the file exists because I used the 'browse for file' option. Can anyone help?

Craig/Nagaraj, Thanks for you help so far. Part 2: I have created my script and now have a list of files that I would like to process. I know that I can use a start loop stage in a sequencer job to loop and process all the files in my list. My question is how can I pass the file list to this stage? ...

Craig is correct. I only want to retrieve the remote files that I need (i.e. not processed). There could be a lot of files in the ftp server directory, so I definitely don't want to get all of them. Thank you for taking the time to respond. I guess I need to write a script to retrieve the file list.

Craig is correct. I only want to retrieve the remote files that I need (i.e. not processed). There could be a lot of files in the ftp server directory, so I definitely don't want to get all of them. Thank you for taking the time to respond. I guess I need to write a script to retrieve the file list.

I have the need to retrieve a list of files names from a ftp server directory, then process some of the files found in it. I don't think that I can use a folder stage in a server job because of the need to enter a username/password. I don't think I can use a ftp stage either. I am not familiar with ...

Can you tell me how to set the user status?

Actually all the jobs within seq1 failed. Seq1 is a sequence job which runs the same job multiple times with different input files. Seq1 failed because it couldn't open the input files. Okay, let me ask this question. In my masterseq, is there a variable that I can use to check if any jobs in my sub...

I have a sequence job, masterseq, that calls another sequence job, seq1. There are two output links on seq1 in masterseq with triggers set up as follows. One link with a custom "success" trigger: seq1.$jobstatus < 3 And the other link has a "Failed" trigger. When seq1 fails the m...

Ken, The DS server is in Orlando and the Progress db that we are extracting from is in Houston. Being an old pick guy and relatively new to DS and ODBC, can you tell me what you mean by the "ODBC connection manager" and "switches". If you're talking about the setup options when I...

Thanks for all the responses. Here's the answers to all of your questions: The database that I am connecting to is PROGRESS SQL92 V9.1D ODBC driver is DataDirect 4.1 I tried adding a transformer with a 1 = 2 constraint. The extract still progressively slowed down. I did try in-process or Inter-proce...

We are extracting data via an odbc (Progress) connection directly to a txt file. The larger the target txt file gets, the slower the extaction gets. The job eventually aborts. Example: job starts off at 150 row/sec, slows to 66 rows/sec, then aborts. Additionally, it never aborts at the same place. ...

What's New at Release 7.5 Release 7.5 brings many new and improved features to DataStage. Job Sequencer Manny enhancements have been made to the job sequencer, including the ability to loop within a sequence, the option to automatically handle errors, and the capability of restarting a sequence from...

I'm not familiar with the term 'wire' driver. I've been a UniVerse/Unidata programmer for 15 years and all this Database stuff is new to me. Is SQL Server a 'wire' driver? I've been importing table definitions from it for a while without installing the client.

Thanks again for your responses.