DSXchange

Hi everyone,

I am waiting for your answers! Can you please tell me if there would be any compatibility issues?

Thanks,
Gaya3

Hi,

There is going to be a DB2 database upgrade to 9.5 in our projects. I need to know if there would be any compatibility problems with the DB2 plugin. Currently we are using DB2 versions 8.2 and 9.1 and the jobs are running fine.

Thanks,
Gaya3

This is the error message

Error calling subroutine: DSR_IMPPLG (Action=6); check DataStage is set up correctly in project <project name>
(The connection is broken (81002))

and I am trying to connect to an AS400 file.

Hi, I am trying to import table definition of a DB2 table. When I choose the 'Import Table Definition' option, it prompts for server name, user id and password. After I give the credentials and select 'Next' I get an error message that 'Datastage is not set up properly' and the client loses the conn...

Hi all,

I have decided to invoke a script as suggested by DSDexter in the After Job Subroutine to remove the characters for now.

Thanks everyone!

Hi Ray, Iam not using a Sequential File Stage. I have used OpenSeq and WriteSeq commands to write to a flat file in a Job Control. Is there an option to avoid the occurence of ^M characters while writing to the file itself? I would not prefer to remove the characters after the file has been created,...

Hi, I have written a job control to capture the job summary using DSMakeJobReport and to write this information to a sequential file in a loop (for each job). I am able to see the expected result in the output flat file, but I also see ^M characters at the end of each line in the output. Can anyone ...

Hi...I am not able to the see the Premium contents.

This is not a derived column and I have not changed the meta data after creating.

Can you tell me if there are any specific rules in defining the columns in a UV stage? Can I give decimal as the data type? Or does it have to be integer or numeric?

I am able to see the value clearly in the hash file that Iam creating in the first job. I tried to give 24.95 in the input (and can see the same when I try to view the data in the hash file) and it is .2495 in the UVstage output. It is exactly moving two decimal places for every value. What could be...

Hi, I am facing some problems with the universe stage. I am creating a hashfle which has two records. I am trying to query this hashfile using sql in the universe stage. When I try to do this I notice that a particular field with a decimal value (eg 2475.68) in the hash file appears as 24.75 in the ...

Thanks Craig for the information.

I will mark this topic as resolved!

Oh, thanks Ray. I must have misunderstood your other post. Can you suggest me a better option for version control in 8.0 version?

Hi, We have recently upgraded the DS version from 7.5.1 to 8.0 and we find that the version control functionality has been removed in the latest version. I was looking through the posts regarding any available alternative for Version Control in 8.0 and came across some information regarding Informat...

Hi,

Thanks for the response. But I am not a premium member and I am not able to view your reply completely.

Can you please resend the steps that I need to follow so that I can view the reply completely.

Thanks in advance,
Gayathri

Hi, I came across this issue today morning. We had problems with the datastage server in the unix environment. Due to this the server was restarted. Once the restart was done, I was not able to connect to my project through the client. 1) But I was able to see the entire directory structure in the u...