DSXchange

Yes I have, I have done each and everything written in the product documentation.

Anyway can you tell me the way to check if I have binded correctly or not?

Hi,

I changed it...but still the problem persists

Hi,

Probably... How do I check the DB2 server name?

Hi, I have my DB2 and Datastage installed on the same system. My DB2 server instance is db2inst8 and client instance db2inst5. Now I am trying to connect to DB2 server through db2inst5 client instance(that is what my requirement is keeping in mind high availability stuff for DB2). I have cataloged t...

Well, I faced the same challenge but i could do it in the following way. You will need to have one common sequence job and a parallel for this Parallel job Datastet1 -------------------->>>Dataset2 Parameterize the Dataset name in the Dataset 1 and put any name of your choice in Dataset2 Sequence Jo...

Hi,

I have installed IIS 8.5 on Linux Red hat, on a pre installed Db2 9.7 with instance db2inst8 at 60000 port.

Now we want to use the instance db2inst5 on a different port, please let me know what are places where i need to make any change.

Hi Ray,

But there has to be some way by which i can take this entire row in one string through a column export stage, and the try to remove all the whitespaces after the the delimiter "~".

I guess in this case the whitespace between the characters need to be kept within the string.

Hi,

I have to install Datastage 8.1 on Websphere Application Server 7.0 on Red Hat Linux OS Platform, I just want to know whether there will be any compatibiltiy issue or not.

Resolved it by setting Record Delimiter as UNIX NewLine

hi Ray,

I have kept it as Char(2) and Char(10), but still getting the same error

I have my source data as follows: - 10Pending 20Hold the width for the fisrt field is 2 and second is 10, I have added space char after the data in the second field to make it 10 characters long. I have set the Record Length as fixed, and i have defined under the string type option in the extended c...

Nagaraj wrote:may be you can use a uv command to LIST all the job names in the project directry, and write it to a file and then search in that file....this shd give you the syntax.

Yes that i am thinking,but how can go to UV prompt and save job name to file....

Hi all,
I am wokring on a log generation utility using unix shell scripting,here i m trying to find out existence of job name and project name in DS server.Is there any unix command to retrieve these information,any suggestion.?? I want to write script like

If you have spaces that will not handled in implicit conversion. Use Trim and StringToDecimal functions. Hi There is no space in source data because when i m using Transformer instead of Modify it working perfectly fine but in modify its giving warning message! and StringTodecimal function i cant u...

Hi all, I m trying to convert varchar(20) to bigint 20 using modify stage.As it is written in the manual that for string to int64 conversion,there is no need to write any function i.e. it is default. but when i m running a job,data is going to output link of modify stage. Job is giving warning messa...