DSXchange

Figure out exactly what you want to do, and create the shell script. Use exit commands within the shell script to control the exit status value; for example exit 1 causes the exit status to be set to 1. ExecSH is a "canned" before/after subroutine. You can inspect the code in the Routines branch of ...

I think the problem is with the length of the original date, it looks like "2006-11-22-11.40.11.801933" . i can get it to look like "2006-11-27 18:07:35 then i think it should work. Left(InLink.TheString,10) : " " : Ereplace(Right(InLink.TheString,15), ".", &...

Check for three things. Is there an entry in UV.ACCOUNT for this project? (Note that the table name contains a dot, not an underscore.) Is there an entry in UV_SCHEMA for this project? (If so, you will need to use VERIFY.SQL to remove it.) Does the physical project directory still exist and, if so, ...

Can we save the metadata definitiona at a later stage and use this method? Yes, using Save from a job design also establishes a linkage that Usage Analysis and other analyses can use. (However it does not save format information for sequential files.) During the Save dialog be systematic about your...

The transmission mechanism is still built the same way, so the same calculations apply. It just uses the backplane, rather than the actual network.

Your problem is that your data do not conform to your metadata. One (at least) of your rows contains a value in the VarChar field that is too large to fit into the Char field. Use a substring function to effect the appropriate truncation. Or delcare the Char field large enough. I presume from the fu...

Have you tried two functions?

Even Search can help you. Reading through the Change Capture stage chapter in the Parallel Job Developer's Guide will provide you with the rules.

Perhaps the answers on the other active thread on this issue would be a good place to look.

maneesahmed wrote:Unfortunately, We have not used the metadata defintions in manager.
So cannot use the same to track the job.

This is the correct conclusion.
You WILL use the table definitions from the Repository in future, won't you?

What are the data types of the reference key and the parent key?

You're a kind-hearted soul, Roy, obviously with little exposure to sales staff in the IT industry. Read Dilbert more often. It may also be that there was confusion between legacy QualityStage jobs (which do become read-only, apparently) and DataStage, but I prefer to preserve my cynicism on this one.

Job parameter containing the full file name?

It may merely be a limitation of the data browser. That's why Arnd suggested you use the Len() function to verify.

IBM. All courseware will be issued in 8.0. As to transition training, I don't know - maybe someone could ask IBM? Ask whether your support provider intends to provide transition/installation training/mentoring as well as support. You might also ask how THEY plan to get trained.