DSXchange

the datatype is varchar and the if-then-else construct is correct why can't it be used for the derivation. The derivation for the variable is " and TO_CHAR(B.srvc_from_dt,\'yyyymmdd\') = ORCHESTRATE.SRVC_FROM_DT" OR " and TO_CHAR(B.srvc_from_dt,\'yyyymmdd\') >= ORCHESTRATE.SRVC_FROM_D...

Hi, I am trying to write a dynamic query in Oracle using Datastage variables that get set at time of job running. I am getting errors from the way I am tying to pass the date into Oracle. I have defined a stage variable: srchQueryDateRange - that will hold the date portion of my query, the variable ...

Has anyone worked with 8.7 new looping feature of SaveInputRecords and GetSavedInputRecords. I am trying to use this function but all I am getting is an error: APT_CombinedOperatorController,0: Internal Error: (xfer_->initialFixRunLength_f == initialFixRunLength):./../include/apt_internal/api/transf...

When you write your query from the Oracle table, you will need to do the following:

select (to_char(BLOB_FIELD)) as BLOB_TXT from SrcTable

And have your column defines as LongVarChar (4000)

This works. I used KeyMgtGetNextValueConcurrent("MySeqName"). But here is the problem. Is there any way to reset the value to start from a certain value? I know that it stores this value internally. I can probably write a routine using the KeyMgtGetNextValueConcurrent routine. Any ideas/c...

It sounds like you are using Write Method = Load, If so, add the option:
Disable Constraints = False
Index Mode = Rebuild

Thanks for the help Ray, I copied CREATE.FILE SDKSequences 2 1 1 out of the routine, and was able to create the table, and then my sequence.

Mona

I am trying to start a sequence in Datastage for a new instance. I have a development, integration and model environment, and now that I am moving to the model invironment, I want to start a sequence within SDKSequences table at a specific number. I have tried the following:UPDATE SDKSequences USING...

Thank you Ray, that was what I thought.

I am still relatively new to DataStage, and we are supposed to have Enterprise Edition version 7.0.1. Can someone tell me how I access SAS in this version. Is there a special plugin that is needed which will make the parallel stage within the Tool menu become active? Everything that I have read pert...

I am still relatively new to DataStage, and we are supposed to have Enterprise Edition version 7.0.1. Can someone tell me how I access SAS in this version. Is there a special plugin that is needed which will make the parallel stage within the Tool menu become active? Everything that I have read pert...

Thanks a heap !!!

Thanks again Kenneth, I have figured out the logs internal file number, but I'm not sure how to delete this log. It's RT_LOG403. When I tried to delete the actual server job, I get the following error: Cannot get excluse access to log for job DWAddress..... which is the name of the job I am trying t...

Thank you Kenneth !!!!! :D That cleared the status, now I only have to be able to clear the log file. Thank you again.

Mona

Thanks Kenneth, I have tried that, but the Director just hangs. I wasn't the person who submitted this job, I'm was designated as the Administrator, so I'm left holding the bag, trying to kill this monster. I'm beside myself right about now. I've only worked with DataStage about a month, so this is ...