DSXchange

Thanks Craig,
but search did not really help.There are only basic routines which call the function but none of the post tells how to run it from uvsh.

Any example will be a great pathfinder !!

:idea: Is there any possiblities so that I can embade datastage Basic functions like DSAttachJob,DSGetProjectInfo etc into a Unix script OR can I call this functions from Universe shell ?? I know ther are other ways of doing this from datastage CLI but I want to explore the combination of Unix shell...

Well..I had the simillar issue but it worked when i ran following in series it worked,you can try this out !! $ cd `cat /.dshome` $ . ./dsenv $ export LIBPATH=$LIBPATH:$APT_ORCHHOME/lib $ export PATH=$PATH:$APT_ORCHHOME/bin $ export APT_CONFIG_FILE=/opt/tools/ds/Ascential/DataStage/Configurations/XX...

version 8
---------------
New SCD stage.
Parallel job range lookup
Browser based admin console.
User lever security settings.
The metadata server
Improved SQL Builder
Improved job startup times
Better GUI

These are the major addition to DSv8

I have newly created environment where everything works fine but I am facing a strange issue.In its simplest form I am trying to execute this query from Db2 API stage "SELECT '2008-10-11' as TICDATE FROM sysibm.sysdummy1" and when I click on view data from stage itself It shows me the same...

But I can run tar command from home directory and it is set in the PATH variable -

PATH=/opt/tools/ds/Ascential/DataStage/PXEngine/etc:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/dstgadm/bin:/usr/bin/X11:/sbin:.:/home/cfdsi04/sqllib/bin:/home/cfdsi04/sqllib/adm:/home/cfdsi04/sqllib/misc

I am trying to install datastage on AIX box.Installation last for atleast 10 min and then fails with the following error - ============================================================ Launching Parallel Extender install Wed 25 Mar 17:52:49 2009 =======================================================...

I had a simillar scenerio in datastage v7.5.2 and i did following - .Used a transformer macro DSJobStartTimestamp and write this value to a seq file having only column JobTS(timestamp 10). - Then used this file in another Job and pulled the value for further use. This approach may help you in DS v8 ...

You can copy using orch commands !!

orchadmin copy | cp source-descriptor-file target-descriptor-file

your error is because you are using input field as DATE and the conversion function is integer.YearFromDate return INTEGER.Change the datatype to CHAR 10

This transformationw will give you the desired result -

((YearFromDate(link.Column)-1) :'-': link.Column[6,2] :'-': link.Column[9,2])

Where link.Column is your date field coming as an input,So If you have link.Column =2009-03-12 Then the result will be 2008-03-12

its already installed,i cant change the system,is there any other way ?

How can I stop developer to log into Admin client? Right now developer has rights to log into DS Administrator because development ID belongs to dstage group.

Any work-around for this ?

thanks.....This is what i was looking for,now i can start working from this point...

yeah i have taken the Dx437 classes but still I am not fully confident of doing that..making an normal config files seems easy and i did that but the job in cencern definetly need a highly tuned config file.. Below is the config file i made and using but it gives a run of 3 hour to that job.do u thi...