DSXchange

VPN AND FTP ARE TWO DIFFERENT PIECES.

VPN MAKES THE CONNECTION BETWEEN TWO REMOTE SYSTEMS,

FTP TAKES CARE OF MOVING THE FILES ON THAT CONNECTION.

BEFORE COMING TO THE DATASTAGE YOU NEED TO START A VPN CONNECTION / SERVICE . THEN DO FTP WORK WITH DATASTAGE .

HTH
NEENA

You cannot end your job with transformer.
There shold be atlease one output is eeded for transformer.
Then use a stage variable and @INROWNUM condition to come out of transformer
Thanks

First divide your updates and inserts by using transformer and for insertions use BULK loader and for Updates user the OCI stage.
This will imporve your speeds of data transformation
Thanks

CHECK DIGITS Routine

Thanks

Check your Path and run the command

Hi Muru,
Check the Datastage Basic Guide for
DSGetJobInfo Function
and DSJ.LINKROWCOUNT
Hope this works for u

Hi Try to use a user defined Sql in the input stage (Oracle) and tryto use a join commnad over there. This makes ur job more easier.. Hope this works.. Tnks, Neena Hi All, I have 1 million records in Txn File and 500 million records in a second table T2 in udb database. I need to do a join between T...

Hi Nice solution ..Kenneth filestage --- transformer --- hashstage. You can create hasfiles as either file on file system or you can create that on UDB which is Project workspace. Select the filename and metadata in the file stage and make sure that one or more keys in it and just drag drop the fiel...

Hi Stafford,
This is Error message is for the file system and you are trying to create a file on the file system which is more than 2 GB . Send a request to the unix admin to change the system from 32 bit to 64.
Hope this works
Tnks,
Neena

Hi Ram, This depends how your project is designed. The main issue somes with the Sequencers. You need to build/edit those sequencers again. We never tried this before ( renaing with script on export file).. I suggest to go manually and replace the names with convensional names. Tnks Neena All, We ar...

Hi Fong, We are also in the same sinario couple of days back, Our data looks right, I don't know what is your case but we are using the DS7- CFF stage We are getting a binary file and we are using the same scinario. I will look in to the problem again and try to solve it. Thanks, Neena Hello, We are...

Hi
Clear table and Insert Rows uses the Truncate as of my knowledge.
Thanks,
Neena

Hi, When I create a new project, where can I found the default file for the global variable like $PATH, $TMPDIR and the User Defined ? Thanks Pey Hi, you can view these datastage variable through administrator. If you choose project properties General tab you can find a button Environment... when y...

Hi as ray said

Before the job runs, execute this command (perhaps through a before-job subroutine invoking ExecDOS):
type file1 file2 > file3

or
copy A+B C

both woks to merge two files in to one

Neena

Hi Nag I found this problem once. In my case i am running my client as Admin ( windows primary administator) and solution is i created a user under the admin group and tried to connect . This problem is solved but my version of DS is 6.x. Try this 1. create a user under the adminstrator group 2. log...