DSXchange

If you configure Sequential File Stage with below properties and everything else to the defaults or however you need them to your file needs, any record with more (or less) than specified number of columns will be rejected. And you can actually capture these rejected records in a reject file with er...

i had pasted the same query in Target stage(Update SQl in UPSERT MODE) and the job is finished the records are not updated. Perhaps you can try running the script in enterprise stage as a target with sequential mode using delete method. In same situaltion it worked for me. Use Row Generator stage a...

3 streams in the same job? that means the increased number of operators. As the number of operators increase per job, the amount of scratch memory/buffer required to allot for the job is also increased. Since each operator requires it own memory pool. Each operator shares its operation among nodes. ...

Documentation that comes with software pretty much covers all you need except how you organize your projects, configure file management, creating categories and jobs. "Install and Upgrade Guide" (pdf file installed as part of the software installation) has all the documentation needed to a...

The name of the variable is $APT_NO_JOBMON. Why would anyone want to move this environment variable? This is an environment variable pertaining to job monitoring service with which one can control the performance statistics in the director and designer. There is supposed to be a java application ca...

You can have a small shell script which executes those multiple unix commands. Seems like you are trying to print the file size with "grep #TargetPath#/TargetFileName# | awk '{print $5}'". Did you mean doing a listing with -l argument and then searching for the file like below? ls -l | gre...

Not sure about the user hierarchy in version 8.0 but usually you have 3 types of users which are Developer, Manager and Operator. What type of user are you? In other words, does the "user name" that you are using to access DS have developer privileges? If it is set up as operator type, the...

The problem we face is that multiple sequences may call the same program simultaneously and DS doesn't like this. Does anyone have any suggestions on how we may accomplish this without creating multiple duplicate programs. It seem odd that DS doesn't handle reuseable modules to well. The special pr...

Do a search with key phrase "Unable to initialize plug-in".

Check this below post out.

http://dsxchange.com/viewtopic.php?t=10 ... e0b3f57959

And also try to find Ray's white paper.

Is it working now?
Are you using user defined SQL?

Take a look at this post and see if it can be of any help.

http://dsxchange.com/viewtopic.php?t=11 ... e0b3f57959

srinivenigalla wrote:I want to use Datastage server job in which I dont have FTP plugin.

Doesn't matter if it is server or parallel, FTP Plug-in is available in both.

May be you don't have the stage in palette or it could be that it is not selected when the software is installed ?

You can not use DB2/UDB Load Stage as a source. It is a bulk load utility provided for UDB and can only be used as a target. DB2/UDB API also known as DB2 Plug-in Stage is used for reading and writing data from or into DB2. API stage should do well for reading or writing 1 million rows. But certainl...

FTP Plug-in Stage does the job.
I would use DS Job to do this kind of task only if other DS functionality(Transformations) is needed as part of file transfer.

But if you are looking for only file transfer on UNIX, secure copy (remote file copy program) SCP is more reliable and faster as well.

It is nothing to do with Teradata. Yeah, I know. Project Level parameters do not work in all stages. Go figure. Thats not true. They do work in all the stages. Resolving Project defaults ($PROJDEF) or environment ($ENV) variables in the jobs is nothing to do with the actual Databases. As long as you...