DSXchange

Simon, That is a wide open question and the answer depends on a number of things, including what type of databases you are using for source and target. For example, if you are using ODBC to access the source system, you could read one row from the target (select max(created_date) from target_table) ...

Hello All,

I have a table that I wish to up date on a daily basis. I have a field in the target table created_date. What is the easiest way to get the MAX created date from the target table, and use that as selection criteria on the source table.

Regards,

Simon V

Has anyone come across this error before ? This is a transform job Seq --> Transform ----> Seq with hash file lookups running on DS 5.1 on Solaris 8. It is only intermittent and I cant repeat it. ***************************************************************** Message : DataStage Job 339 Phantom 92...

If you havent tried this already, bump the trace level up in the FTP stage and perhaps youll get more information. Youll need to check the parameter help on it to know what the different trace options are. -craig "Jennifer Weise" To: Subject: Re: FTP Problem 03/08/02 11:00 AM Please respond to datas...

Hi Riccardo... Which API are you referring to..... the Job Control API for starting/stopping DS Jobs? or the Job Edit api that we used to offer that allowed editing of Job and other DS designer objects? Ernie -----Original Message----- From: Riccardo Tani [mailto:rtani@datamat.it] Sent: Friday, Marc...

I am trying to FTP from NT to an outside vendors server when I get this error. My settings are the same as yours and I get the error listed below. Error while trying to open connection for sending data to the FTP server, socket call connect failed. Thanks. >>> rtani@datamat.it 03/08/02 10:55AM >>> H...

We run on Sun. Thanks, Leonid "Hall, Doug" on 03/08/2002 11:01:14 AM Please respond to To: "datastage-users@oliver.com" cc: Subject: RE: Job control error -14 What is your server platform ?? We run on AIX and had a similar problem. We changed the &PH& directory to a type 19 for each DataStage projec...

What is your server platform ?? We run on AIX and had a similar problem. We changed the &PH& directory to a type 19 for each DataStage project. -Doug -----Original Message----- From: lfrumke@sears.com [mailto:lfrumke@sears.com] Sent: Friday, March 08, 2002 10:16 AM To: datastage-users@oliver.com Sub...

Hi, Ive got this warning in control job: CCSCDialerDnldBatch4.JobControl (DSRunJob): Job control error (-14) (DSRunJob) Job UpdateDasJob4 has not logged any events since #2709, and appears not to have started after 1800 secs Job UpdateDasJob4 runs in every even step of the control job. We never had ...

Hi Jennifer, i have just tried to send a file via FTP from NT to UNIX. It work fine. This are the properties in the FTP stage that ive changed from default values: Stage/Properties tab: Server Name: 10.1.1.28 User Name: User Password: ====================================== Inputs/Properties tab: Rem...

We currently run Datastage 3.6 on Unix. We have a unix after job script that ftps a file to an outside vendor. The script listed below works successfully every time. open someaddress.com user someuserid password ascii prompt mput filename.txt quit We are now converting to Datastage 5.1 on NT and I a...

Hi all, does anybody know if its possible to use Job Control API also with DS5.1a on NT? If it is, which is the library I have to include in my VB/C++ project? In prervious releases this was possible by including "jobapi.dll" but now i cannot find it in the client installation directory. Thanks in a...

ed, its also worth noting, what we are (badly!) explaining here as Ernie said, is the ability to run multiple instances of the same job, a job can be designed to take advantage of running on several cpus, such as taking parts of the source through different instances of the job. However, your email ...

Now you have to backtrack in the program to establish the real function name for which GET.Pin%%V0S29P1 is a synonym. My guess is that it will be $DS.INTGETNEXT, which is performing a "get next row" operation on the link whose identity is given by V0S29P1 (probably the stream input link to the Trans...

Yes. We have one rowin the table with null value for key columns. Thanks for your help Saravanan "Raymond Wurlod" To: Subject: Re: DS Warning Message 08-Mar-2002 12:07 PM Please respond to datastage-use rs Sender Info: No Sender Info found in the address Book Somehow a NULL has gotten into a row you...