DSXchange

Just a silly question - when I import a sequential file definition, I will point to a sequential file in a directory to do the import. Afterwards, I can delete the sequential file I used for the file definition, right ? Dirk Moolman Database Administrator Reach Technologies South Africa www.thefuelg...

I would not use SQL to look up on a Universe hashed table - full stop. -----Original Message----- From: Alexandre Stoulov [mailto:alexs@tern.ru] Sent: Thursday, October 18, 2001 8:27 PM To: Tony Curcio Subject: Re[2]: Lookup question Hi guyes! What do you think about such decision: I use Uv table sa...

Hi guyes! What do you think about such decision: I use Uv table satge as lookup stage and user-defined sql: SELECT HashFile.lookup_code, HashFile.name FROM "HashFile" WHERE HashFile.lookup_code = (SELECT MAX(HashFile.lookup_code) FROM "HashFile" WHERE HashFile.lookup_code = SUBSTRING(? FROM 1 FOR CH...

dsexport exports the whole project.
The only way (at DS 4.2) to export individual components is using Manager.

I would have used server side routines to do this and then these could have been called from a suitably defined server routine to do the same thing. Phil -----Original Message----- From: Kenneth Bland [mailto:kcbland_2000@yahoo.com] Sent: Thursday, October 18, 2001 9:29 AM To: datastage-users@oliver...

HI, If DS server is installed in NT server, the following command can be used to unlock the job. The command can be executed from client (Provided you connected with Server) and Server as well. From the Client: Login to server through Telnet. (IP address of DS server can be used to login) You will b...

Just to clarify what I said earlier, we avoid insert/update but have had no problems with update/insert. If it was appropriate to your processing requirements, I would have no hesitation in recommending update/insert. I would track down and address the jobs with insert/update but I wouldnt worry abo...

We are on DS 4.0.2 with ORAOCI 2.3 on Solaris 2.6. If you are right in DS not reporting errors on the first statement, then there are potential for rejects not reported using either. Ill test update/insert when I get a chance. Most of my other jobs, I have a lookup and then an insert only link and a...

The job designs are passed to your DS Manager client, where the design information is then encoded by VB logic into the dsx or xml formats. Almost no activity takes place server side. If you write your own server side export logic, you will have to recode all of that VB code into Universe BASIC so t...

You could write one - The issue would be keeping it up to date. You could test your code by exporting it via the client method and then with your code and diff the results. -----Original Message----- From: Kenneth Bland [mailto:kcbland_2000@yahoo.com] Sent: Thursday, October 18, 2001 3:45 AM To: dat...

I wonder if the routine calls could be changed to accept n parameters like transformations can or whether this a constraint on the underlying mechanism. Regarding the insert/update update/insert, where possible you should split the inserts and updates into different links. Phil -----Original Message...

David, Many thanks ! Any thought on why they didnt want to do have this lil feature ? Regards Bibhu --- David Barham wrote: > Now thats an easy question. The simple answer is > "no". (Unless someone > added this without telling me). > > -----Original Message----- > From: Bibhu C [mailto:bibhuds@yaho...

Thanks for our reply David. I wish datastage handled dates as easily as Oracle does. Requirements on date arithmetic is uniform, regardless of source/target database characteristics. The date & time conversions (via Oconv & Inconv) are okay but handling midnights and leap years are another cause of ...

Hi Henry, have you tried to use DSSetJobLimit??? I think this can help you. Regards, Riccardo ----- Original Message ----- From: "Nowell Henry" To: Sent: Wednesday, October 17, 2001 5:56 PM Subject: Abort after 1 warning only > I have a control job containing approximately 12 jobs or so. In one > of...

I have a control job containing approximately 12 jobs or so. In one of these jobs only, I need to assign the preference of aborting after 1 warning. The reason is that: 1. I am loading a large target table with several rows. 2. Instead of reading from this large table in the next job based on the sa...