DSXchange

Also realize that you cannot recognize an empty file inside a job to process it and note that somehow. That one you'll need to check separately. Elsewhere.

Just to confirm, you specifically mean the last 'occurance' in a delimited string, yes? That was your 'for instance', just wanted to make sure that would cover all of the bases.

Why don't we start from the beginning. You haven't posted any specifics about the query you are running nor what "my file" might be or where exactly you are running this query. However, if you are looking for the &COMO& directory, from what I recall there is one in each Project dir...

sendmkpk wrote:can i run this command anywhere else and get the output

And there was no need to post this question in three places. I've deleted the other two so we can wrap this up where it started.

I assume you are talking about this issue.

What elsewhere? Where / how are you running it?

Still curious what their target is...

I guess no nulls have been encountered as of yet...

Or:

Sorry - missed that part. So I would wager it is working fine just not putting the files where you'd really like them. Have you looked in the Project directory? Without directions to the contrary in your unzip command, the files will end up in the "current working directory" which for a ru...

XMETA supports the new topology and integration into the Infosphere platform, uniVerse is for legacy support... and I do believe all of the legacy structures are duplicated in XMETA.

Why don't we start with... the error(s) you get. I could guess but I'd rather not.

8.7 gets mentioned in upgrade scenarios because you can do an "in place" upgrade to higher versions from there. You can go from any lower version to 9.1 using the full stand-alone "export / import" process. Well, any within reason, of course.

OK... a signed number with an implied decimal. So about this need you have. What is your target - do you want to read it into a string so you end up with an explicit sign (+/-) at the end? Or you just need it to be a properly signed decimal? Assuming the former as the latter should happen automatica...

You could in a Server job.