DSXchange

Define what "read" means here. What exactly do you need to do with this file?

Several ways. What have you tried? One way would be to substring off the first two characters and check them, possibly in a constraint: YourField[1,2] = 'zz'

You could also look into the Filter stage.

what is the difference between ./ and . ./ ? One works and one doesn't? :wink: The first just executes it which means it creates an environment, sets the variables in it and then exits, destroying the variables. The second does much the same but the variables are created in your current environment...

DS_JOBS stores the job type in a field called JOBTYPEIND from what I recall so you shouldn't need to rely on a naming convention. Search the forums for the various values and caveats on its use.

pandeesh wrote:Yes..we can use Matchfield () in a job sequence

Right, we know.

We're not discussing Parallel jobs here but rather Sequence jobs and/or BASIC routine code.

Yes, that.

iHijazi wrote:I must say that ankesh solution worked like a charm, thanks buddy!! Simple and straightforward

marpadga18 - if that's not enough to help, please start your own topic and let us know what problem you are trying to solve and what issues you are having...

By account-based, I would think that means the hashed file will live in the default location of the DataStage project directory that it's created in (UV account = DS project). Yes, and automatically have a VOC record associated with it. Best Practice is to avoid that as much as possible as filling ...

Ken Bland used to hang out here and post all kinds of interesting information. For example, check out this post and especially the other post linked to in the first reply from Ken.

What is the "this folder" that you are looking for?

There's no way for it to change one query into another like that. I'd suggest you really check that you are seeing what you think you are seeing. Is that logged query from an older run with an initial version of the query? Are you in fact looking at the correct job's log? Try right clicking on the S...

Now you are in the proper forum for suggestions of this nature.

I don't see adding another forum, people have a hard enough time putting things in "the right place" as it is. As of now, adminstration discussions go in the General forum.

Use a Surrogate Key Generator stage for the number itself, afterwards pad it with zeroes to the size you need and concatenate a "Z" on the front.

That's ok... it's just that "real time" has some connotations that I didn't think you meant to bring to the table.