DSXchange

Thanks - I've used these magic settings ($PROJDEF), but I obviously misunderstood $ENV. Though now I'm equally not sure how to use it. Inside a job, whether an environment value is retrieved from the shell or project definition is irrelevant, right? So it would only make sense to use whenever changi...

Don't think so - I've never used $ENV, but if I understand correctly, it sets the default parameter to the value of the environment variable at compile time. Subsequently, if a value would need to be changed the job would have to be recompiled in the right environment. This wouldn't work.

Variables are not "known" since I'd need to replicate parameter set functionality without using parameter sets (e.g. a new parameter set value set requires 4 new project variables and the calling sequence cannot be recompiled/ edited - the value is retrieved at run-time from the environmen...

The tech note is at this address http://www-01.ibm.com/support/docview.wss?uid=swg1JR47902 , but I since found out it is only present in v11 (this is the reason why it wasn't working on v9). I am trying to find a way to duplicate the parameter set functionality (for non-technical reasons that I will...

Hi folks, Due to non-technical reasons, I am trying to pass the value of an encrypted environment variable to a DataStage job from within a calling sequence. The environment variable name is not known at design time and therefore is not a parameter to the job. I found an obscure technote that DS is ...

Hi Rj, This was just an example; there are any number of possible individual errors that appear in the source and provisioning for all their various combinations in the standardisation phase would be much more costly (both in time and resources) than enhancing the standardisation function (I don't e...

Howdy, I know this is a long shot and probably not possible (in an IBM approved manner), but is there any way to override the string comparison function used in the classification? E.g. Word of HERTFORDSHIRE has a tolerance of 700, but it will not match against IERTFORDSHIRE. It will happily match a...

It's unlikely the source data will have a column called nothing, but "nowarn" also works.

How about being just slightly more specific with your mask? "0N'.'0N1A0N" in conjunction with the MatchField() function should work with a full (five piece) scientific notation number. If the numbe ... I can't see your full point and I may be missing something, but it doesn't seem as stra...

Howdy, For reasons too convoluted to explain, I need to interpret numbers written in scientfic notation and I need to do that in basic. I'd need to extract the sign, the base, the exponent sign and the exponent. To somewhat duplicate the functionality of QS, I initially thought of using pattern matc...

How are you calling the stored procedure? What have you done so far? What's the procedure signature?

Can you use an output parameter instead of a return code and map to that instead?

Howdy, I'm trying to simplify the work required for data lineage so now I'm looking at ways to automatically derive the lineage from datastage jobs. I have three sources: - design time information; - operational (run time) information; - user defined information. The design information is gathered c...

Hi, I am trying to convert a decimal to string using the "string_from_decimal" modify function and write that to a file. The only trick is that the separator needs to be a comma (",") and has to be without leading/ trailing zeros. I see three choices. The last one works but is le...

Thank you

Hi all, I remember on version 8, there are two pivot stages: Pivot and Pivot Enterprise. However in the documentation, only Pivot Enterprise is documented. This was not an issue as I always used Pivot Enterprise. However, now I have to develop a job in 7.5.1 and need to look something up. I tried to...