DSXchange

Hi Ray,

My userid is configured for cron.allow. I would really appreciate if can help me.

Thakns
Martin

Hi,

Read data as single column
Write to 2 output links
Output link1 on constraint do substring Col[1,5] = '06TGT'
Output link2 on constraint do substring Col[1,7] = '0625TGT'
with this you can create 2 seperate files.

Goodluck
Martin

Hi,

Would some one help me with script to schedule single DataStage job on UNIX box to run evry day at 6pm.

Thanks
Martin

Hi scorpion, If you want to join 2 or more source file to one file, You need make sure Metadata is common or You need to map source file columns to common Metadata and link to Link Collector. 1). Make sure 2 source file / Database Table have common Metadata. Or 2). Use Transform Stage to Map to Comm...

Thanks......Kim Its working

At OS level I used mv <old hashfile name> <new hashfile name>
then i set Q pointer to external directory in DS Admin and ran query but it returnded error Any Idea where i went worng.

Martin

Chulett / ArndW

Hashfile we have created are not upto standard naming conventions, and we want replace old names with new meaningful names, Instead of runing DSjobs and creating new hashfile.
All our hashfile are created outside project area into external directory.

Thanks
Martin

Hi Guys,

Can i change Hashfile name instead of deleting old and creating with new name, the way we can do in database sql.

Thanks
Martin

As per Kcbalnd I am writing to Seq File and capturing Max Key value using Transformation Routine......Its working the way it has to work. I also tried Ray method and bit confused using . TRANS ( [DICT] filename, record.ID, field#, control.code) 1. I defined SETFILE <Full Path> in before-Job Subrouti...

Hi Ray, I tried your code TRANS("/Ascential/Datastage/DEV/Ha_RequestDim', "REQ_ID", 1, "X") I got error DataStage Job 85 Phantom 31381 Program "JOB.1638071665.DT.1386332505.TRANS1": Line 51, Unable to open "/Ascential/Datastage/DEV/Ha_RequestDim" file. Da...

Hi Ray,

Thanks for the reply,I will try and let you know.

Rg
Martin

Hi Guys, I have a design, which pulls Max SUK from Hashfile, and passes to Transformation stage to generate Next Key. Now I want to get rid of these extra stages and processing time, and replace with ROUTINE which can read Max SUK from Hashfile created out Project Area. If any can help me with Routi...

Thanks........Chulett, you are correct, I was under ipmression we dont have NULL values.

Now its fine with Not(IsNull(lkSmpDescs.smpid))

Martin

Hi,

I have a simple job creating Lookup file. I was able to create and run sucessfully but for some reason its giving error

LdSampleDimPTLnPML..Ha_SampleDim.lk_SampleDim: ds_uvput() - Write failed for record id '<Missing or NULL>'

Any Clue what does this means.

Thanks
Martin

Hi Mahi, 1. Open New Job > Save > Job Properties > Parameters > Define Parameter for Parameter file name and Location > goto Job Control 2. Define DefFun as first line DefFun GetParm(arg1, arg2) calling "DSU.GetParm" 3. AddJob into job control 4.Define Parameter parmParameter = GetParm(par...