DSXchange

This is a topic for an orphaned message.

Hi Ricardo This is even before running, when you try to view the data in the ODBC icon on the designer. If the username and password is correct, the data views. If it is incorrect the job just hangs, no reply, no message, no anything. When you do an action like viewing it starts a UV process, and th...

Hi, I am running DataStage 5.2 on Solaris 8. Everythings been working fine, but suddenly when I try to run a job in a sequence, I always get this error: DSD_SendEvent.B:Error Starting run The log details say: Cmd = SH -cActivityCmd START -file MSEVENTS/20020612120030000 Output = ERROR: Couldnt get I...

Hi, but which is the job status when the odbc hangs?? Is it still running?? ..or finished?? Riccardo ----- Original Message ----- From: "Yzelle De Wet" To: Sent: Wednesday, June 12, 2002 8:27 AM Subject: RE: AS400 ODBC username and password hang. > Morning Gents / Ladies. > > I have tried the driver...

Hi Julie, try Trim function: Trim(String," ","A") This function will "trim" all unnecessary ("garbage") spaces! Hope this will help you Riccardo ----- Original Message ----- From: To: Sent: Wednesday, June 12, 2002 3:29 AM Subject: Replacing of text > > > This should be an easy one, but I cant seem ...

Hi all Im running Datastage 5.1 on unix and I am encountering the following problem: I have a batch job which is running, and when I try to stop it, it doesnt. the jobs that the batch job calls are not running (finished), so theres no reason for the batch job to keep running. any advice? Denzil

Morning Gents / Ladies. I have tried the driver from another application. Oracle and Excell and both from the DataStage server. It seems DataStage is the only application that has this problem. Thanks for the help. Yzelle De Wet -----Original Message----- From: David Barham [mailto:david@barham.hm] ...

A passive stage such as the ODBC stage (or any other) only connects to a single data source/target. What you need to do is read from one of the tables using one ODBC stage and from your transform, do a lookup to the other source. This is how DataStage effectively performs joins across different data...

hi all Mark, thanks for ur reply. I have another problem regd datastage which is concerned with two sources. I have an dept table in Sqlserver databse and I have another table by name Emp in Oracle. I want to join these two tables based on the deptno condition How can this be done?. What I did is I ...

This should be an easy one, but I cant seem to find the correct answer in the help I have a name that has been concatenated together, and in some cases there might be 3 spaces between the first and last name (as there is no middle name). Using which instruction can we replace the 3 spaces with 1 spa...

Have a look at Trim in the online help. This will clean up all leading, trailing and embedded white space. If you wanted to be more precise and just reduce your 3 spaces to a single space (but no other whitespace combinations), you could also use Ereplace(name," "," ") -----Original Message----- Fro...

Hello, It works now. Thanks for the input. As I am new to datastage basic, it took me a while to find a command to display the values for a variable and I finally end up with using DSLogEvent. After several struggles, I found out that I had made a careless mistake on the variable assignment. The DSS...

I will be out of the office starting 06/10/2002 and will not return until 08/15/2002.

Different versions of DS Client cannot coexist on the same machine. You may want to look into a product such as VMWare that will allow you to create "virtual machines" within your Windows environment. You could then install DS 4.0 in one VM and DS 5.2 in another VM (or your native environment). You ...

Hello Paul Reading data from hash files can be tricky. Are you sure that you have assigned VarOne correctly. i.e. have you used a CALL DSLogInfo(,VarOne) to examine its value? Check for hidden characters eg char(254) field separators in your data. I have often used this method to initialise job para...