DSXchange

I am going to try and mimic an exported Table Def in dsx format. I've exported a single Table Def and the dsx seems to be straightforward, a standard header then a repeating subgroup for each column plus standard trailer. Description is one of the field properties ==> Simple loop in VBA. Bit of a ha...

Is it possible to import the column description from a schema file? I have some Excel spreadsheets containing sequential file descriptions, with column names, data types, lengths and a user friendly column description. It's trivial to write a formula to generate an Orchestrate schema file from the s...

Are you using Surrogate Key Generator Stage ?

No, we generally use a routine developed in house. I regret I am unable to share that with you.

Hi Battaliou, Sree I still have access to the code Battaliou is referring to. The problem with the Sparse lookup against a db2 sequence is that the lookup is expecting to do a SELECT WHERE and so requires a key value. If you use the IBMREQD as the key, say IBMREQD = 'Y', this works fine for the firs...

Range lookup is coming in Hawk. Until then there are three possible solutions :- 1. Do the range lookup in your RDBMS wherever possible. 2. For a small number of possible values within the range, generate a reference dataset with a row for each value, do an exact match lookup or join, then immediate...

... opinions as to if it is possible or advisable to set down a firm rule for nullable columns. I guess the conclusion is no, it is not advisable to lay down a one-size-fits-all-occasions null conversion rule. .. comes from a Harry Potter book That would explain Matt's beard ... he fancies himself ...

Thanks, Arnd.

As often happens - you have confirmed my own thinking.

BTW - SettValleyConsulting is actually my old company name, I am more usually known as Phil Clarke, currently sitting three floors above you in Griffin House

Note to self - must sign posts going forward.

This may be OTT for your needs but here is a VBScript to export a project. You could just extract the parts that do the export into a bacth file. '* '* DSPExport' '* '* '* Script to export a Datastage Project. '* '* Export filename is named after Project + Date '* '* Phil Clarke. June 2005. '* '* '*...

I am currently setting out some best practice guidelines for DS EE developers in our department and want to canvas opinions as to if it is possible or advisable to set down a firm rule for nullable columns. We have two schools of thought. One camp maintains that nullable columns cause too many probl...

Consider periodically clearing down the phantom directory. Phantom is the Datastage term for a subprocess ... eg the process spawned by a routine called by another routine or by a job. The output from these phantoms is written to the phantom directory named &PH& beneath the datastage project...

Is there any function for calculating whether the given date is last day of month? like last_day in sql??? Maybe I am missing something but I don't think Ray's premium solution works, or completely answers the question ... I think Ray's solution returns the last day of month that a given date lies ...

Apologies for the duplicate post ... I thought that the first version had disappeared into the bit bucket ...

This is a fairly common requirement - 'housekeeping' after a run that creates large temporary or intermediate datasets for example. Note that 'orchadmin rm' can accept multiple filenames as arguments. Here is the business part of my script to delete a defined list of datasets, you will need to modif...

This is a fairly common requirement - 'housekeeping' after a run that creates large datasets for example. Note that 'orchadmin rm' can accept multiple filenames as arguments. Here is the business part of my script to delete a defined list of datasets, you will need to modify the path names for your ...

I'd suspect RCP as the culprit, magically reinstating SOURCE_CRNC_CODE because it's in the schema somewhere. I thought so too, I suspected RCP was propagating the column despite the explicit DROP, however I switched RCP off in the lookup and the stages immediately upstream and downstream and still ...