DSXchange

Please give more information as to how you are loding your file and how you are reading it. Are you updating/inserting the file the same time you are reading it or is it a load first and then read it case. In the latter case, you can use the Allow stage write cache option. If you are concurrently bo...

The problem is that you are trying to update the table before commiting the inserted rows. To overcome this, set the rows per transaction property in the ODBC stage(where you are inserting the records) to 1. i.e. commit after each row is inserted. But be aware that doing this will give you a poor pe...

I just specified "sort -u" in the filter command and input file name in the file name property of sequential file stage and it worked just fine. I mean without specifying the file to sort in the filter command.

Is there something that i am missing?

Thanks
Dhiraj

. All the Filter command does is execute the command as entered and the stage then reads 'standard out' as if it were a flat file so do i also need to specify the input data file in the filter command ? does datastage not indirect the file specified in the sequential file stage to the filter comman...

Hello, How does filter command in sequential file stage work? does it read each line in the specified input file and pass each line to the filter command using indirection and uses what ever is output by the filter command for processing, including any informational message? I am presently trying to...

You could but all the files you create would be enclosed in a folder.

Use the folder stage as your target. Folder stage takes 2 columns as inputs. first is the file name and the second should be the entire record concatenated (or data that you wish to write to the file).

Regards
Dhiraj

Hi Kumar, Inorder to query a hash file using relational operators , You should use the Universe stage. Refer to the following post. http://www.dsxchange.com/viewtopic.php?t=92083 And ideally to perform a look up based on the value retrieved from another look up you should use 2 transformers.perform ...

and yes Could also be an issue with free disk space on your database.

Regards
Dhiraj

looks to me that datastage is deleting records from the database and not truncating the table,hence your transaction logs are getting full.

Try trucating the table before you run the job.

Regards

Dhiraj

Hello,

What is '/backups/Projects/Test ' ?

The syntax for using DSJOb is

dsjob -jobinfo <projectname> <jobname>

If Test is your project name then it should look like

dsjob -jobinfo Test LkpProvEast1


Regards

Dhiraj

I was looking at Ken's SetDefaultParams job which was posted at ADN. Presently i'm trying to customize this for my own requirements. I have couple of questions about this 1) this job was written for version 5.1 , Does it work for version 7.1 as well? 2) i observed that the job updates columns 14 -20...

Bryan, There are config parameters in the uvconfig file which you can change to define what level of file sharing is required. By default it is link private. i.e each link loads its own copy of the file in memory. it could also be set to 1) link public sharing . i.e multiple streams shares the singl...

Kevin, Go to the properties page of the transformer where you are doing the lookup --> inputs tab ---> select your look up link from the drop down list-->check the box which says link returns multiple rows.i am assuming you are using ODBC stage for look up Search the forum. This has been discussed e...

oops. Craig is right. don't know how i made that mistake. We use parameter for batch start date in almost every job !

If you are using the field function in a transformer, then you can.
Remember you should enclose the parameter name within # symbol.

eg Field(#DSN#,'|',1)
Where DSN is the parameter name.


Dhiraj