DSXchange

I have had this problem when importing imf files from systems in locales where the decimal point is a comma not a period.

Bob.

I would try reimporting the meta data from QS in to DS if only because IBM support will ask you to do that anyway!

Reimporting quite often fixes problems.

Bob.

The log files for QS are great for that sort of thing. If you look at the /logs folder you'll see what I mean. I think it might be easier to have a script which write the start time to a file, runs qs and then writes the time to the same file immediately after qs has run.

hth

Bob.

Not actually seen that message as such, but here's a few things you can check if you haven't already: Does the QS job run okay from QS itself? Does the job run from the command line? Check the QS logs in /logs folder. They usually contain more detailed information. Check the input to the QS job is f...

I got this one quite a lot, specifically with Sequences. I haven't yet managed to reproduce the problem on a repeatable basis so I just keep saving on a very regular basis.

Not an answer I know, but perhaps a problem shared .....

qsrtmngr can be tricky to get right! In addition to the checks advised earlier can I suggest the following: Make sure the qsjob has been staged and runs from qs itself In the qs plug-in stage in the job: qsrtmngr default port is 6010 Make sure all references to qs are absolutely correct, they are al...

I've seen this one before, here's a few things to check, if you haven't already done so: Both files exist and have data in them. The files are fixed length. The columns are correctly defined in the files. Have you changed the columns in any previous stan process in which case you may need to revisit...

Guys, We have DataStage installed on an nfs mount with local and active driectory users. It is causing considerable grief at the moment in trying to get a stable environment. Looking at some of the posts I guess you may not be too surprised! We have been able to use DS in the past but we ran in to p...

Thanks, guys!

Easier than I thought.

Guys,

Does anyone know if it is possible to run DS, EE or Server, from within an MKS Tools environment?

I am using MKS Tools to provide a unix environment on a windows platform. I should also state that this is for investigation purposes, not true development etc.

Thanks,

Bob.

Try looking in the log files, difficult to tell from the output given so far!

@FM is char(254) and is used by DataStage as a separator on many occasions. I think its the separator for arrays, for example. I would try using the ereplace function: ereplace(SourceString, SubString2replace, ReplacementSubString) Its fairly easy to use and the ReplacementSubString in this case is ...

Hi, thanks for the response. Basically, it's a fiddly area! I think your idea works as well as any. One thing that occurred to me from your notes is that you are handling the error with a failure link in the sequence with an error handler routine and then a sequence terminator, I assume. I used to d...

I've just had to think about a similar problem myself and, it its of any interest, here's my situation .... The DS sequence is launched from a script which is launched by a scheduler: Script > Seq 1 > Seq 2 > Job 3 The requirement is to return any fatal error message from Job 3 to the script and the...

I have seen something like this before, but I ca't remember exactly what the cause was. Anyway, here's what I would do: As Ray suggests, look at the Data directory in the project for the file, it won't be anywhere else. Check the logs in the Log directory, there will be more than one so trawl throug...