DSXchange

Ken . . . Thanks again!!

Here is what I get, when I do the sourcing
Thanks . . . Bryceson

I also tried to stick the alias in .profile it does not work!!

Thanks . . . Bryceson

Thanks Ken . . .

How do I source . ./kshrc??

Bryceson

For all the DataStage Unix Guru out there!!! I am trying to set up simple alias for my user id on a UNIX Aix env. Here is how my .profile looks: #.profile PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:. export PATH ksh if [ -s "$MAIL" ] # This is at Shell startup. In n...

Thanks Chulett . . . At the moment I am using PuTTY to get the work done. Even though I am still interested to use Reflection X.

Hopefully folks in the forum are using it . . . . may be I will get a few hits to get it going on my env.

Bryceson

Hi Folks, We are moving our environment from Windows to Unix AIX. We also intend to use Reflection X emulator to connect to AIX Server. Does anybody has used Reflection X to connect to AIX and can be able to aid me here? Two years ago I have worked on Reflection X emulator to connect to Sun Server w...

ArndW,

Thanks . . . Yes, I can see it in DataStage Manager . . . But I can not compile it since it is a ReadOnly. How do I remove the read only on the Routine?? Then I should be able to compile.

Thanks . . . Bryceson

Folks, I want to use the Routine KeyMgtGetNextValue in my derivation on transformer stage. But while in Transformer -> Derivation then right click DS Routine I can not see the " KeyMgtGetNextValue ". What setting do I need to set to activate it in DataStage so I can able to use it?? Thanks...

After your Import . . . .You can compile multiple jobs (all / some jobs in a project) through DataStage Designer or Manager -> Tools ->Multiple Jobs Compile

Thanks . . . Bryceson

Chris,

Look at the begin of the scripts

COMPANY=$1
ENTITY=$2
PROCDTE=$3

You run this scripts w/ three paramaters
(scripts name ->chrisjones IBM product 20060627)

IBM - is your first param
product - is your second param
20060612 - is your third param

Hope this help!!!

Now you're talking . . . . Are all the files the same name with diff date?? CODE: if [ -f ${SOURCE_PATH}/*.zip ];then 1. for i in files1.zip files2.zip files3.zip files4.zip . . . files15.zip OR 2. for i in *.zip do RETURN_CDE=$? unzip -p ${SOURCE_PATH}/$i done else echo 'Zip Files does not exits' $...

Try these CODE: #! /bin/ksh set -vx #Name of Script: chrisjones COMPANY=$1 ENTITY=$2 PROCDTE=$3 SOURCE_PATH=/opt/ibm/data/Projects/WORKSPACE/lnapps/BI/data/ chmod 770 ${SOURCE_PATH} if [ -f ${SOURCE_PATH}/$COMPANY_$ENTITY_PROCDTE.zip ];then RETURN_CDE=$? unzip -p ${SOURCE_PATH}/$COMPANY_$ENTITY_PROC...

Pretty good video and sound, but Pace is a little too fast.

Bryceson

Ken,

Thanks for your knowledge!!

How do I need to handle the surrogate key that are created in DataStage at the project level then if the Hashed files are going to build fresh??

Thanks . . . Bryceson

Folks, We are migrating our DataStage from Windows to Unix and have hashed files that contain Surrogate Keys. If we can replicate the Hashed File directory structure under Windows to a corresponding structure in the target environment (AIX) and migrate all of the files/Data found in that structure, ...