DSXchange

Hi,

When I am try to call a procedure from ODBC Stage in Data Stage PX. I am getting the following Error:

Error executing View Data command:

##F TFPM 000279 16:41:01(019) <main_program> Fatal Error: Caught ORCHESTRATE exception in main program: APT_ParseError: In field: Expected identifier, got: ":", line 2.

I have trying doing the following but still it is not working:
1. I have defined all the decimal fields lenght and precisions.
2. In the table definition in the Repository, choosed the Layout tab, and select the Parallel option.

The same procedure when I call through Data Stage Server Job it works fine.

Can someone tell me why is this:

is there any transformer in your job? and are you performing a trim function anywhere.

Are you using :1, :2 for bind variables?
You are not supposed to use these.

In PX the bind variables can be used by putting ORCHESTRATE.<column_name> instead of your bind variables.

No I am not using any bind Variables.

Yes I am using a Transformer and using trim function also. how does it makes the difference.

Its a known bug in datastage . If i describe it correctly, if you trim a column while using it in any statement or calculation, it throws this error .

Search the forum on your error, it will give you a lot of posts regarding this.

After I remove the trim also. It is giving me the same error.
Please can you suggest me on this.

can you see the generated query, it must be in next line to this error in the director.

or you can see in the generated OSH script