DSXchange

Hi,

In DS OS/390, when we using te FTP, we can transfer files from Mainframe to NT or Unix ?

With best regards
Rui Soares

Hello Sameh Bishara Usually when Im trying to see the load of a job on a UNIX system, provided no one else is logged in Im able to issue a SAR 10 10 This gives me resource usage as the job progresses. Remember your Datastage administrator will give you project specific memory usage for hash files. I...

Thank you for all of the opinion, i have successfully update and insert the data after remove the keyword "LIMIT"..... David Barham wrote: > What is the name of the table you are inserting into? Check the table > name field in the ODBC stage link properties. > > Im not sure if you were trying to hav...

Hi, Looks like LIMIT is a keyword and is expecting parameters when you r using it the second time. LIMIT(ACODE, SERIES, LIMIT, OUTST, ...) ^^^ ^^^ Regards, A. -----Original Message----- From: Peggy Lee Pei Kee (COS-HO-IT) [mailto:peggylee@kurnia.com.my] Sent: Monday, June 24, 2002 7:53 AM To: datast...

What is the name of the table you are inserting into? Check the table name field in the ODBC stage link properties. Im not sure if you were trying to have a space in the table name "CNOTE LIMIT" or is the table name simply "CNOTE", in which case I would remove the word "LIMIT" which appears to be in...

You have a carriage return/line feed after the "SERIES" column. Delete the CR/LF and the error should stop. Chris. Quoting "Peggy Lee Pei Kee (COS-HO-IT)" : > Hi, Im using DataStage 4.0 . my objective is to update and insert > data into a table in SQL database. I have use ODBC stage and choose > upd...

Hi, Im using DataStage 4.0 . my objective is to update and insert data into a table in SQL database. I have use ODBC stage and choose update existing or insert new rows action, an error message occur as below. Does anyone face this problem before? Pls advise thank you. CNOTELIMIT.CTransformerStage17...

Hi everyone, do anyone have a way of measuring resources used by a batch job string or datastage jobs like CPU utilization? Having to justify for more CPU purchases over here. thanks ____________________________________________________________________ Visit us at www.singaporeair.com _______________...

Hi everybody, Do any one know hoe I can measure the memory utilization done by a job. this job contains oracle plugins, hash files, sequential files. with all the write cache option enabled, and the preload file to memory option enabled and with the maximum array size and transaction size? Thanks an...

Shawn, This is what you get for moving those computers all over the Starbucks building. Are you sure you clicked the workstation only check box when you installed it? If you didnt then you will need to create a user id on your box with admin priveleges and then uninstall it. I really hate you guys f...

Thanks for the information, I ended up creating a local account to my NT box that had administrator rights and was able to uninstall DataStage when logged in under that account. The whole thing is a little odd since I installed it with my Domain account. Shawn -----Original Message----- From: Himans...

if youre on a network and installed using network admin role, then you may need to try logging in as the network admin and try the uninstall -----Original Message----- From: Shawn Ramsey [mailto:SRamsey@starbucks.com] Sent: Friday, June 21, 2002 1:00 PM To: datastage-users@oliver.com Subject: Cannot...

All,

I have DataStage installed on my PC for a training class and cannot uninstall it even though I am the local admin for the box. When I go to uninstall I get that I dont have the rights to uninstall DataStage server.

Shawn

David, in order to accelerate a 1 to many lookup for slowly changing dimensions, we were rolling up into a hash file the natural key, start date, and surrogate key. Our primary key on the hash was natural key, and then attribute 1 was a multivalue array of start dates, and attribute 2 was a multival...

Do you call up any routines from the Lookup transform? Ive had an abnormal termination problem before and it was fixed with help from Ascential tech support in Sydney. DataStage 5.2 passed arguments to routines by reference and not by value, if a routine makes changes to that argument it can cause t...