DSXchange

Hi
I have two columns where i need to load as :
TARIH1 = first day of the last month
TARIH2 = last day of the last month.

any help appreciated.

Thanks in advance.

Hi All, I have job design like MQ--Transformer-FoderStage. Initially i was able to read messages from MQ qithout any aborts. Recently i encountered with a very large message of length 134861 and this is the second message in the Queue. Because of this job started aborting after reading first message...

HI I have a job design like MQ--Transformer--Server Shared Container(with Folder Stage in it). I am reading around 15 messages from MQ at a time and creating each XML for each message and storing in a FOlder stage. I am getting the below error when i am reading the file from MQ and storing it in a F...

Hi
I have a job which reads from MQ.
I have set Message Limit as 10,000 and set Destructive Read On.
If i get more than 15,000(say) Messages will the remaining are present in MQ destructing only Messages which are read.
Awaiting your suggestions.

Thanks,
Pavan

The message limit i have given is 1000. But there are only 3 sample messages in the queue. I tried to Force Compile and $APR_DISABLE_COMBINATION = True but it didnt work. Can some one help me how to resolve. Let me know for further information. Hi i am unable to resolve this issue. Operator termina...

SIGSEGV stands for Signaling Segmentation Violation. Check the message volumn of your MQ. The message limit i have given is 1000. But there are only 3 sample messages in the queue. I tried to Force Compile and $APR_DISABLE_COMBINATION = True but it didnt work. Can some one help me how to resolve. L...

Are you trying to store the integer data with a trailing space? Or, are you trying to store varchar data with Trailing space? ... The value is ORD_I = 5000311 which is getting stored in Oracle Table where datatype is Char(40). For the first time records are getting inserted. WHen i am running the j...

SIGSEGV stands for Signaling Segmentation Violation. Check the message volumn of your MQ. The message limit i have given is 1000. But there are only 3 sample messages in the queue. I tried to Force Compile and $APR_DISABLE_COMBINATION = True but it didnt work. Can some one help me how to resolve. L...

lstsaur wrote:SIGSEGV stands for Signaling Segmentation Violation. Check the message volumn of your MQ.

The message limit i have given is 1000. But there are only 3 sample messages in the queue.

Hi I am receiving a following error while running a job first time. "Operator terminated abnormally: received signal SIGSEGV". I compiled and ran the job again: then it says job being monitored and cannot get exclusive access. I tried to clean-up resources and clear status file. but it di...

Hi I am receiving a following error while running a job first time. "Operator terminated abnormally: received signal SIGSEGV". I compiled and ran the job again: then it says job being monitored and cannot get exclusive access. I tried to clean-up resources and clear status file. but it did...

chulett wrote:As noted in your error message:

pavans wrote:the result is non-nullable and there is no handle_null to specify a default value.

You mean:

StringToDecimal(FOB_TYPE_C);
i tried but it didnt work.
Am i missing anything here.

Curious... how do you propose to convert string values like your "WS" into a decimal? ... --------------------------- Even i was surprised to see that. Som else has done the coding and job aborted due to this and i was looking into it for the first time. I didnt realize this. ------------...

Are you sure you need a 'workaround' for this? It's a character field for a reason, which more than likely means you actually have no issue. If somehow that data now needs to be stored in your database without trailing spaces, then yes you would need to arrange to have the field changed to a VARCHA...

Hi I am getting a following error. Un-handled conversion error on field "FOB_TYPE_C " from source type "string[40]" to destination type "decimal[10,0]": source value="WS "; the result is non-nullable and there is no handle_null to specify a default value. The ...