DSXchange

its from sql server, through an odbc connection. Im writing to a flat file to load with a script. The record looks like this "received bloodresults . 04/04 - hgt non -fastened 15.6 mmol 12/04 - hgt fastened 12.4 mmol 7.5 % 18/04 - hgt fastened 9.8 mmol rx was adjust to glucphage 2 mane and nocte ." ...

Hi Denzil, What is your source? Nagesh. -----Original Message----- From: Denzil Sander [mailto:DenzilS@mxgroup.co.za] Sent: Monday, January 06, 2003 1:08 PM To: Datastage (datastage-users@oliver.com) Subject: bold free text field Hi guys I need to import text into a column, but the problem is that s...

Hi guys

I need to import text into a column, but the problem is that some of the
text is bold. How do i convert/replace the bold font to normal font in
datastage?

thanks

denzil

Hi Chris, Ive done this already, but when I validate the job that contains the universe stage, it returns an error indicating that it requires a user id to connect. Now the only way I know of supplying that is by either using the UVNETID environmental variable or the SET.REMOTE.ID command and Ive tr...

You claim that the jobs "abort with error". What error message is in the job log? This will help us to diagnose the possible cause. It is likely, from your description, to be an inability to establish a connection, or that event number 0 cannot be found in the log file. As to performance, what do yo...

What is the error? Rui Soares wrote: >Hi, > >Actually we had notice a bad performance in DS jobs, they run very low. In >most case, we start the jobs, but after same minutes where DS server cant >start the DS job, it abort with error. > >What could be ? >We check in DS Administrator, and the flag "d...

Hi, Actually we had notice a bad performance in DS jobs, they run very low. In most case, we start the jobs, but after same minutes where DS server cant start the DS job, it abort with error. What could be ? We check in DS Administrator, and the flag "do not timeout" is active. We check the "&PH&" d...

Please unsubscribe me, chingkaisern@yahoo.com Thanks. ____________________________________________ Ching Kai Sern HP ..+65 9878 4604 Email ..chingkaisern@yahoo.com " To see a World in a grain of sand And Heaven in a Wild Flower; Hold Infinity in the palm of your hand and Eternity in an hour." - Will...

One thing - the do not timeout setting in the Administrator is for *client* connections and shouldnt be an issue here. What platform are you running on? You may want to try stopping and restarting DataStage and possibly the server itself. Other than that, it would be necessary to have the exact erro...

Hi, Actually we had notice a bad performance in DS jobs, they run very low. In most case, we start the jobs, but after same minutes where DS server cant start the DS job, it abort with error. What could be ? We check in DS Administrator, and the flag "do not timeout" is active. We check the "&PH&" d...

MONTHLY POSTING - DataStage Users List As of 2 January 2003 the DataStage Users discussion list had 732 subscriber addresses. A few of the addresses are to organizations who then redistribute the postings to more than one reader. ================== Posting Guidelines ================== 1) Non-modera...

I dont think it is the query which is the problem. One of the properties in your stage is wrong (pick any value on any tab - I have no idea which). Oracle is not returning this error, DataStage is generating it itself. -----Original Message----- From: ramesh pothuru [mailto:ramesh.pothuru@oit.state....

Hi, I am using user defined sql and running the fallowing statement UPDATE ODXPOTH.DIM_VEND_LOOKUP SET VEND_END_DATE=TO_DATE(:2, YYYY-MM-DD HH24:MI:SS),update_flag=N WHERE VEND_CDE=:1 and update_flag=Y but its giving the error vendlookupL.ORAOCI89: Invalid property value any idea about this. Thanks ...

Thomas, To connect to a remote DataStage Server or Universe Database server, you need to edit the uvodbc.config file in the project directory. The config file contains instructions. Also, this must be done for each project from which you require the remote access. Regards, Chris Mueller -----Origina...

Hi Guys, Im trying to connect from one datastage server to another using a universe stage as opposed to a hash file stage and as far as I can understand I need to make an entry in the UV.ACCOUNT file in the DSEngine directory, but it is not a ascii type file so can someone please tell me how to make...