DSXchange

Hi Praveen You are correct. Parallel job does not have before-after stage subroutine in transformer stage. Can you tell me in which scenario you want to use this feature? Regards Sreeni Hi dsuser_cai, I am looking at Parallel job. I have copied a text from the parallel job developer guide in my firs...

Hi Praveen, That is strange very strange.. Regards Sreeni Hi All, I am checking in Job properties and not in the sequencer properties. I have pretty much worked with DataStage but not on shell scripts and routines. So, I do very well know to access the job properties and stage properties. The versio...

<Columnname>:decimal[53,0] {};

rstemphowski wrote:The input to the Column Import stage is character because it's the whole record defined as one column. How do I format certain columns in the schema file so that the CI stage will convert those columns to decimal[n,n]?

HI..

Schema file is really helpful.
It does away with having one job each of different input format.

Regards
Sreeni

Hi, This is the first time I am trying to use a Before or After stage subroutine in a DataStage job. I have Information Server 8.1 installed in my system. I have copied the below text from the Parallel job Developer guide, hi.. You would have opened a sequencer. Its present only in job propeties of...

Hi All

We have spent considerable time migrating from 7.5 to 8.0.1.
Went through various posts on migration from 8.0.1 to 8.1.

Is the process of migration from 8.0.1 to 8.1 tedious ?
Can some of you share your experiences

Regards
Sreeni

Even one of the IBM experts needed more than ten attempts to upgrade from 8.0.1 to 8.1. Wild horses could not extract that expert's name from me. ... Hi All, We have already spent lot of time in upgrading from 7.1 to 8.0.1 . Is the upgradation from 8.0.1 to 8.1 tedious ? Pls let us know your experi...

Hi

You get Control M characters if you create a file in text editors (E.g text editors other than notepad in Windows) and import the file to unix.


Regards
Sreeni

Hi All,

Do we have any function which would return the "user id" using which the datstage job has run.

I wanted to capture this "user id" and store in the database.

Regards
Sreeni

Hi Guys, You might be knkowing that there is a feature of "Before Job SQL" in Oracle Enterprise stage of Server edition. I came to know that this feature is not present in Oracle Enterprise stage of Parallel edition. :shock: Any idea of how you guys are implementing "Before Job SQL&qu...

Hi All,

Has anyone worked on calling a datastage job running on windows server from a .NET program

This is required so that the Business User can trigger a datastage job from a .NET application

Regards
Sreeni

HI , To implement MINUS (of oracle ) in datastage you can do in two ways: 1. Write the query containing MINUS in userdefined sql 2. Use a hash lookup making all the columns as keys (with a non unique contstraint) and reject if all the columns match. Regards Sreeni Hi all, I want to perform the minus...

There's no way you can execute "a bunch" of different sql statements from a single link, you won't be able to bind everything properly to the columns in the stage. Which is exactly what your error say ... As Chulett says you cannot execute multiple sql statements in user-defined sql. User...

Hi You can use the removeduplicate stage in parallel version (if the project architecture allows this) Regards Sreeni You need a work around. Either load your file to a temp table and then perform regular sql. OR create a dummy key with running sequential number while creating the hashed file so tha...

Hi Duke, Thanks for the inputs I understand the competitive constraints. My only curiosity was whether the suggestion specified was possible or not ? Regards Sreeni I doubt if anyone is going to share these types of tools. First of all it is a difficult thing to support. Second it is a competitive a...