DSXchange

Hi Melinda Thanks for that At the moment we have a set of progress 4gl programs which dump the data to ascii files, we then use oracle sqlldr to load data into oracle. This process is very time consuming and are looking to speed up this process and to avoid creating large datafiles Do you have any e...

Scott, We had a product from Progress Software called "Oracle DataServer" which allowed you to connect to Oracle via Progress. You could then use the Progress 4GL to read and possible write to the Oracle tables. We just read from them. You could purchase this product and use it do handle the convers...

Yah, found that out about the tree late yesterday. To me these kind of knee jerk removal of features bothers me - "we have this new tree display which you can drag stages from, who needs the Insert menu anymore? Yank it!". Wheres the harm in having both and letting people decide which one works bett...

Anybody took data out of a progress database and populated an oracle database.

Heard there is a problem connect to progress database through ODBC

Scott

OMIT is only for connections using LAN Manager where you can automatically logon using your network password. To me this means on NT only, the help says dont even bother trying this with a UNIX server. I dont know about NT, but on UNIX flavors of DataStage youll only see jobs scheduled under the use...

Very true. I was just trying to explain how it is typically used, which is the unconstrained, catch-all type of reject. You can certainly mark a constrained link as a Reject Row, but all that would seem to buy you would be the fact that the number of rows going down it would get logged automatically...

Hi Kasia, If passed into DSRMessage it gets turned into a newline. Regards - Chris Thornton -----Original Message----- From: Kasia Lewicka [mailto:katarzyna.lewicka@cgey.com] Sent: 19 February 2002 08:47 To: datastage-users@oliver.com Subject: Meaning of In a routine I have the following lines : If ...

when i run the client from my desktop i have OMIT specified and it works fine. -----Original Message----- From: Phaneender Aedla [mailto:phaneender_aedla@mindtree.com] Sent: Tuesday, February 19, 2002 9:08 AM To: datastage-users@oliver.com Subject: RE: job schedule overview I think the OMIT works on...

Thanks Glenn, happy for Daves vacation holiday )) Me too Ive increased it to 768 on my DS 4.2 on Sun. Thanks again for you clarification and your support. Best rgds Giovanni Boccia Sales Engineer Direzione Industria e Servizi Datamat - Enabling Your Future ----- Original Message ----- From: "Glenn H...

I think the OMIT works only if u r logging onto a computer where the server is installed. And I guess if u want to see all the job schedules, u need to login as an administrator. Regards, A. -----Original Message----- From: Himanshu Patel [mailto:Himanshu.Patel@globalknowledge.com] Sent: Tuesday, Fe...

Giovanni, Dave is on vacation this week. To answer your question, the configuration parameter does nothing but set the upper-limit to the number of characters that comprise the record ID. This does NOT increase file size and does NOT increase access time, but it DOES increase the amount of shared me...

Ive never had that situation in our system as we only have 2 DS developers / admins. Wehn you first start DS Director up, You enter the server name and select the project. are you entering a user name/password in the login boxs ? Try skipping that piece by checking off the OMIT check box. This may a...

Thanks for the quick reply, but maybe my question wasnt very clear. I know how to schedule jobs from within director but what I dont know is how can I see which jobs are scheduled by other persons(other user ids) regards Luc -----Original Message----- From: Himanshu Patel [mailto:Himanshu.Patel@glob...

since im not sure how youve got your job set up, ill outline one of my jobs.... data input stream into a transform. define your stage variables to handle your data checks define your contraints out to a temp text file or directly into another transform that handles the exception error good luck hima...

Scheduled jobs can be scheduled from within director. You can scehdule a given job a number of times depending on your needs. using director, select a job, click on the CLOCK icon/buitton now right click on the job you want to schedule and select "Schedule" Select, run today, next week, next day, da...