DSXchange

Just define your source field as character of the appropriate size, typically half of the output size. Character field into the sdk routine in your derivation, integer out.

DataStage does not support clustering. That's not to say you can't run it in a clustered environment, but it's not 'cluster aware' in any sense.

And just for completeness, please always say 'hashed file' not 'hash file'. That gets him going, too.

1) Load it into a work table first, then 'select distinct' from there to your target table. 2) Sort your data based on that field, then use stage variables to only pass the row with the first occurance of 'column name'. 3) Load into a hashed file keyed on 'column name' then source to ODBC from there...

I tried to create one sequencer job but whenever I put the Jobactivity tool to the repositry and then clicking properties,the job becomes hanging and I have to make End Task. Windows XP with Service Pack 2 (SP2) installed? You'll need the 'SP2 Patch' to resolve problems like that, if that is the ca...

SOA Edition, actually. No pee. And you can purchase something called the Web Services PACK which is all about calling web services from DataStage jobs. It gets you two lovely little stages: Web Services Transformer stage: An active stage allowing you to call a web service for each record through a j...

Seems like it's hacked out of something like a PowerPoint presentation: "Let me describe the elements of the Ascential suite starting from the center and working out"...

Then it should be working fine... right?

If the question is simply how do I use a column twice in the generated sql - once in the where clause and once not - you need User Defined SQL for that. Simple example: UPDATE TABLE X SET Y=A WHERE Y=B Pass the column in twice (different names, of course) once with the old and once with the new valu...

Chat with your Admins, let them know what you are trying to do. They will be able to help get an RSA Key generated. You'll then need to arrange to have it 'installed' on the target server. And then your batch file - without any mention of userid or password - will work. Google will also turn up inst...

kumar_s wrote:If sftp works from command prompt, shouldnt it work the same from batch file from windows?

NO

It's also a mechanism for a Premium user to expose Premium content to the world - intentionally or not.

sibysjoseph wrote:Now if i have to avoid that and take the password from the file what is that i have to do ?

First suggestion... read my post.

First thing I'd worry about and check would be disk space where DataStage is installed.

It's secure ftp, folks. You cannot supply passwords to it like this, period. You need an RSA Key on the target system to allow 'passwordless' access. Or fall back on 'regular' ftp, if allowed.