DSXchange

Hi All,
We are using MS SQL server as our Database and DataStage is installed on Unix Server.

Can we pull data from MS SQL Server thru DataStage and process it. If it is possible how can this be done.

Any inputs on this will be welcome.

Thanks

Hi Pavan,
Can you tell me how did you convert the varchar field to Integer.
My requirement is also to convert the varchar to Integer.

There are two copies of the same job one job compiles and works and the second one does not even compile.

This problem has been there for sometime.

What is your requirement ? Is it that you need to move records from file to DB2 table and get record with latest date from DB2 table and then wrtie to target Db2 table or is it the of the records from both text file and DB2 table you need to get record with latest date. if your requirement is the th...

Hi, In one of my jobs I am using StringToDecimal function. Input to this is a varchar column. Data in this column is of nature "2314123 dafsdf adsfas 2132" or "123123" or "123213231 SDFASD". It varies I need to extract the first numeric part and then convert it to Integ...

In a Database Stage you use to write the records to a target table, we observed that DataStage stops loading to the target table when ever there is primary key violation. No record is loaded from the point of violation if the violation occurs at record 1 then 0 records are entered.

One possible cause would if you are assigning this job parameter value to a Stage variable or operating on job parameters to the Stage variable and then use it , in such a case you should define the Stage variable type.

if every thing looks fine just could be problem with metadata.

Hi,
if you already have a transformer doing the transformations
added to those you need to split the records based on the range of a column value then better you implement this in transformer using Link Constraints and Stage Variables.

For small operations like this Filter would be a better option.
Transformer is more robust than a Filter Stage. :D

From my experience, a Join Stage works same as a Database join (output wise). There is every possibility of getting output no of records more than in put. You are dong a left outer join Suppose you have 10 input records(left link) and 6 records on right link. Out of these 6 records 3 records match w...

Hi, When ever you are using a function on an input column which is nullable, it is better you handle nulls explicitly. Otherwise the records would be dropped when ever a null is encountered in that field. As rightly pointed in above mails you can use IsNull or NullToValue functions to trap nulls.The...

Hi, What is the difference between DB2 API Stage and Enterprise Stage. I know that API runs in sequential mode while Enterprise Stage can run in both parallel and sequential mode. What is the difference in the logging modes of these stages and what are the different features that are different in th...

Rightly said by Ray, you can directly write the text to timestamp, if the format is valid timestamp. You have funtion StringtoTimeStamp. But better to directly write the input if in right format else this would unnecessarily increase function call and reduce performance when volume of data is high.

Hi, I am getting alpha numeric value in a String column ex"1232123 ABZC". Now I need to extract these two values to seperate columns. I tried Field function to extract these two values seperatly. But when I try to convert the first part of the string to numeric value (i used StringToDecim...

Hi,
We are facing a problem when ever we change the join type.
We have two inputs to a join Stage link A and link B
A-left
B-right and join type Left outer join.

This combination works.

But when we change the order of the links

A- rigth
B- left

Now we use right outer join.

Hi, I am getting alpha numeric value in a String column ex"1232123 ABZC". Now I need to extract these two values to seperate columns. I tried Field function to extract these two values seperatly. But when I try to convert the first part of the string to numeric value (i used StringToDecima...