DSXchange

Hi - Not that my input has anything to do with this matter - it is just a curiousity. Even though you use encrypted for the parameter containing the password you can easily decrypt it by making a job with some source --> transformer --> flat file (having at least one row going through this transform...

Hello again,

Use the link I sent and just click on download, fill out the information required and they will send you a trial version.

Regards
Peter

Hi Ger, On Ascentials E-services web site there is a white paper describing a lot of the things you should be aware of when upgrading. Unfortuantely it is written for version 6, but I would think that the information in the white paper will apply in your situation as well. If you have a valid suppor...

Hi Praj, You can get a pretty good impression of the tool on their web-site - there are screen shots and a videos of how PM works : http://www.datastagexchange.com/PM/ I haven't really used the tool but my initial opinion is, that it looks like a nice tool. It seems very easy to change, add or remov...

Hi -

Use the Field function :

If Arg = 123719,27319

Field(Arg, ',', 1) will return 123719
Field(Arg, ',', 2) will return 27319

Regards
Peter

Hi - Sounds to me that you actually don't read the file you expect. I would double check that. Provided it isn't the correct file that you read then try to execute a "head 1 <possible-filenames>" (forgive me if the syntax is not correct) to find out which file you actually read from. Regar...

Hi - Try using some of the built-in transforms for converting data from EBCDIC to Ascii. Especially I would think that the transform "DataTypeEbcdicToAscii" could help. Provided that you use Client Access as your ODBC connection have the following in consideration - Don't know if it is a p...

Hi - Thought that I should had added a comment to why we do this - so we don't look like complete DataStage novices. We currently have a number of job-sequences all connected in a "master" sequence - so we only have to schedule this one sequence. It is very unsophisticated but works just f...

Hi - We have a job-sequence which is created in the graphical job-sequencer. There are around 150 jobs in this sequence. The problem is, that the generated code is wrong. It executes the jobs in a completely wrong order and terminates after around 20 jobs - with no errors. Has anyone experienced sim...

Hi - Don't really know if this will speed up the performance compared to the solution already suggested - which is what I believe that you want to obtain. Haven't tested it - but I believe it should work : Make a hashfile with the value you want. In a transformer you declare a stage variable. Set th...

Hi - This is turning into a really interesting discussion and there are some very good points. It seems to me that based on the answers then the graphical job-sequencer is very cool when you are not yet familiar with Basic or don't really need very complex job handling - which I guess is not that su...

Hello again - Thanks for the input. I must admit that I hadn't really noticed that many differences in job-sequences between 5.x and 6.x (or 7.x for that matter). Currently I only have access to and work with 5.x (we will upgrade during fall - and I am really looking forward to do that !) Kenneth - ...

Hi - What exactly do you mean by.... :) Probably a lot of the "first-time-posters" doesn't realize how good this forum actually is to give useful answers - to specific questions. So when the questions are a bit vague and there wasn't an immidiate answer the perception might be that it woul...

Hi - I am just curious and would like to hear some opinions about whether you use Job Sequences or you code batch-sequences in Basic for the job-sequence-environment (or both). In general I would say that it is possible to make much more sophisticated batch environments with Basic code than with the...

Hi -

Sounds to me that the behaviour is correct.

If the lookup doesn't produce a result then NOTFOUND is true (implied in row NOT FOUND ) - so you need to negate it in order to get the result you want

eg. Not(LinkName.NOTFOUND)


Regards
Peter