DSXchange

ambasta wrote:Thanks a lot Kumar.My problem is resolved now.

Oconv(Input.column,"MTS") - retrieve the numeric data from the field

As your where clause includes the column CYCLE_MONTH, oracle should use partition pruning to limit the partitions accessed by the query. How many partitions are there and how many are you putting in the parameter when running the job? I assume the table is range partitioned? Run an explain plan on ...

ray.wurlod wrote:Are there indexes on ROLE and CYCLE_MONTH?

I have index on ROLE and oracle partition on CYCLE_MONTH.

roy wrote:Hi,
Do you have the $DS_ENABLE_RESERVED_CHAR_CONVERT set to true in your job properties?

Where/How i can found this flag?

Jay wrote:Try to view 10 rows or 1 row at least...

View of 10 rows successfully opened

Jay wrote:Need more info. Can you please copy paste the error message when you try to view data?

Thanks
Jay

It is very big table, i think this a problem.
When i try to open it it is stuck a long time.

ray.wurlod wrote:It is a partitioned table? If so, have you specified the Partition Table property in the Oracle Enterprise stage?

Yes, it is a partition table.
I didn't understand if it is a partitioned table i can't define partion in the oracle stage?

I removed the where clause , but view data doesn't work.
The parameters ok.
but i will try to check DBA trace.

thanks

Hi all, I try to query a very big oracle table (~50M records), When I use sequential access the job works fine , but very slow. When I try to use parallel access the job just hangs with no explenation. I tried to add some APT env variables for debug but still I get ho clue for the reason the job doe...

thanks

Hi all,

Somebody used the READLIST function?
Is it get only the keys or a full record?

thanks,
Juliya

thanks

Hi all, i wrote routine in which i read from hashtable by : SELECT doneFile to 1 DONE = @FALSE Loop Call DSLogInfo('In Loop', 'Job COntrol') READNEXT key FROM 1 Else DONE = @TRUE ... the readnext command read by key, but i want read 2 columns from hash where the first column is key. How i can do it?...

Please help, I have store procedure in SQL server, which use the open query. When i run the job which triggered the store procedure by ODBC stage i get the error :" IF9MIF_CCP_CallProc..MSSQL_SP.CheckStatusSp: DSD.BCIOpenR call to SQLExecDirect failed. Statement was:{call Phone_Directory.dbo.Up...