DSXchange

It also violates NATO, KAOS and BATMAN. Look, access to DataStage and DataStage login is very secure - in fact you can just use the LDAP or operating system security and that makes the server secure. ... Datastage itself might be secure, but it gives out easy access to the systems it accesses. Unle...

So you are from Michigan, what a coincidence, the IP address of the anonymous person who keeps adding that entry onto Wikipedia is 204.74.160.15 and according to an IP Locator that's from Grand Rapids Michigan. I hope you are the person who keeps adding to Wikipedia because this is a far more appro...

This post has been removed by the EDITOR at the request of IBM. Please DO not attempt to repost this as it will cause your immediate removal from the site!

Thank you for your understanding in Advance.

Editor,

Dennis James

Hi all, I had a small requirement in shell script. In the Input directory iam having input file as RATE3092008033101.csv I have to change the above file as PRICE3092008033101.csv and save the file in another directory. RATE should be replaced by PRICE. And the input file names are not fixed , any n...

Hi All We are scheduling a Data Stage Job to be started every day at 7PM which is getting me the incremental load from a database. My select query is as follows select * from XX where datetime >= (sysdate-1) Records are being pumped in to this table every second. Is there a chance i will miss out s...

kausmone, this happened to every column.. and yes, datatype of the source and the target column are the same.. And Ultramundane, i dont understand.. what is Ecase 74157? Thanks all for replying... Ecase 74157 references a bug fix created by IBM. If you would like to get the fix from IBM you should ...

How to integrate 2 data marts

The Monte Carlo method should work well (especially for steep slopes) to establish several random points that you can use to sum the parts.

Dear all, i have a problem here. i made a job.. oracle stage - transformer - Dynamic RDBMS all i want to do is transfer the data from oracle to sqlserver.. but i dont know why, the data inserted to sqlserver always truncated.. like : 'John' will become 'Joh' I put a peek stage before the Dynamic RD...

Dear all, i have a problem here. i made a job.. oracle stage - transformer - Dynamic RDBMS all i want to do is transfer the data from oracle to sqlserver.. but i dont know why, the data inserted to sqlserver always truncated.. like : 'John' will become 'Joh' I put a peek stage before the Dynamic RD...

No, I have checked that ps -ef will NOT see the job's password. Yeah, I think you're right. I am remembering that for some of the stages the passwords are exposed at the command line in datastage by doing a ps -ef | grep echo because it passes the passwords to "/usr/bin/ksh -c<variable>" ...

From what I understand, this user is required to run a KSH script. This KSH script does a variety of things including a DB2 connection. The user want to know how to prevent the DB2 call from exposing the password. The solution is to shift the connection script into the DB2 command file (db2 -f[file...

So, why not just create a job using the DB2 stage, with an encrypted password parameter, to connect to your DB2 database and does whatever the script is trying to accomplish on the database. ps -ef will still display this as it is being passed to the job. That is, until parameters are shifted by ds...

Why would this fail as it is getting the values for all required 16 params from the Param_Script? Because dsjob was coded that way. dsjob is not smart enough to ignore parameters which are specified that do not exist in the job. If you want to do this, you must write your own code to parse the para...

need to develop a job where i have to "read" 3 columns from a table (source sql server 2000) and need to pass them to sequencer then sequencer shud pass it to shell script then shell script has to pass it to ESP so that if all the values from these 3 columns is "success" then ES...

Hi Chulett, Thanks a lot for ur reply. We are having 800+ jobs and at present we are having 20GB. So will you please suggest me how max would be the memory space. Thanks for the help. Regards, Raji 20GB? Is the 20GB also being used by developers to store files? Run a find command and find all files...