DSXchange

Thanks chulett,

I guess the quotes are the problem. I have a field hard coded in the SQL.

May i know the APT variable i should use ?

thanks
Sree

Hello, I am facing an error with a Datastage 8.5 Parallel Job. I have a job that reads from a mainframe DB2 Table (Using DB2 Connector) and writing into a Teradata Table( Using TD Connector). The job is running fine when I keep the SQL Statement (that reads from the source table) in the DB2 Connecto...

Hi,

How can i find the last update timestamp of a job/sequence ?

thanks
Sreelal

Thanks for your reply Ray & Rajeev

Ray,

Yes. default is 'Fail'. But without giving any condition is there a meaning for this default value ?

Also is it not same as giving a condition and setting the 'Condition Not met' option to 'Continue' ?

Thanks,
Sreelal

Hi

Setting 'Continue' option for 'Condition Not met' clause is equivalent to setting no conditions. Correct ?

Or is there any use of this combination ?

thanks,
Sree

ray.wurlod wrote:What is your "Lookup Failed" rule? ...

Ray, The lookup failed rule is 'Continue'
and no condition is set.

Sainath.Srinivasan wrote:Can you view the data ?

Yes. I am able. to view data.

Sainath.Srinivasan wrote:What kind of lookup is it?

Are you able to view data?

It is a normal look up to an SQL Server table and I am able to view data.
The lookup stage has the reference link 'Entire' partition and the input stream auto.

Hi,

I am getting the following error message on a lookup stage looking into an SQL Server table through ODBC stage.


"The runLocally() of the operator failed."

What could be the root cause for this ?

ODBC_CO_LOC_GL_V_LKP,0: The runLocally() of the operator failed.

Thanks,
Sreelal

Hello,
I am getting the error "Invalid number ORA-01722" when i try to view data from an oracle stage.
The table definiton of the stage was imported from the table itself.

Thx,
sri

thanks for the info.

Hello, While changing the trigger properties of a job activity in a sequence, my datastage desinger vanishes suddenly. I tried many times by opening a new citrix connection, and opened the designer again. But still, it is getting closed suddenly when i make changes as mentioned above. Please share a...

Hello, I am trying to insert/update into an Oracle table through a parallel job. The Oracle stage throws the following fatal error. ORCL_LAWSON_LBRCHG,0: Array execute failed for insert: [insert SQL Statemnet appears here ] sqlcode is: -1003 esql complaint: ORA-01003: no statement parsed Can anybody...

By "Job Type Control-M component" do you mean a controlM job which executes a Ds job ?

Is this the only way, because in the controlM window that I have, the parameter tab is inactive.


-Thanks,
Sreelal

Hi All- Can anybody help me out!! Requirement: I need to get the system variables from control-M tool such as Order date,OredrId for any particular datastage job and pass it on to some script ex : Runanyjob.ksh. as input parameters. In my case the datastage server and Control-M server are different ...