DSXchange

Thank you. The script seems to be the easiest solution, but i didn't want the task to be DBA dependent, so i was looking for the alternate solutions. Thanks Chulett and Craig for your responses.

Hello, I want to insert a default row (Ghost row) into a table if target table count = 0 i.e., if it is an initial load and don't load the default row if table count > 0. Is it possible that i can give this logic in 'Before SQL' tab of DB2 API stage to insert or not to insert, based on table count? ...

PaulVL wrote:Try logging in to the web console and disconnecting all of your active designer sessions.

Hi Paul,

It is not the problem of Job Locking, It is the problem of the Client Designer disappearing and job locking.

Hi All, I was trying to run a Master Job Sequence ( Which have 100 Job activities in terms of 10 parallel blocks ). When I was trying to compile the job in Designer the designer hangs and disappears all of sudden. When I try to reopen the job it says the job is locked. What is the way to get around ...

You have to make sure to match the input and output metadata when using a Funnel Stage.

I could overcome the problem with the following.

SELECT cast(value_text AS Varchar(8000)) value_text from dbo.table

Thanks for some valuable notes from the blog.

Regards,
Sunny

Hi ,

I have a similar kind of issue, I am trying to read a field on sql server though odbc connection and trying to write to a file. The field is defined as text in source. I get the following error

main_program: Datatype Not Supported

Any Ideas, of how it can be resolved..

Found this on search http://sourceforge.net/projects/cb2xml/. A java parser job can be used to populate the required.

Search on Routines and there is innumerable amount of information already availaible.

Hi, I have a wierd problem here. Some how my Datastage Interface doesn't show the mappings within the transformer. All my existing jobs are working fine, which shows that there is a a mapping, but just that i cannot see. I dont remember doing changes to the settings. I can just see the column names ...

Hi Ray, I tried the following as mentioned dsadm@dldatas01:/opt/IBM/InformationServer/Server/DSEngine/bin> ./dssh DataStage Command Language 8.0 Licensed Materials - Property of IBM (c) Copyright IBM Corp. 1997, 2006 All Rights Reserved. bin logged on: Tue Feb 9 16:43:44 2010 >SELECT * FROM DS_JOBS;...

Hi, I am trying to execute a query from the dssh folder, but it gives me the error below. dsadm@XXXXX01:/opt/IBM/InformationServer/Server/DSEngine/bin> ./dssh DataStage Command Language 8.0 Licensed Materials - Property of IBM (c) Copyright IBM Corp. 1997, 2006 All Rights Reserved. bin logged on: Tu...

I have to perform enhancements to already existing jobs. My first step was to tune the SQL. I need to pull the Source SQL. How would I query the log to get the following information.

Hi,

My requirement is to get source SQL from each job and have the information on a file. There are altogether 150 jobs. What will be my approach to have the information on to a file.

Give detailed information about the the message that you are getting