MQSeries.net :: View topic - Why charcater vailable value is null?

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Why charcater vailable value is null?

Why charcater vailable value is null?

« View previous topic :: View next topic »

Author

Message

se_zn2003

Posted: Sun Aug 18, 2013 12:56 am Post subject: Why charcater vailable value is null?

Apprentice

Joined: 07 May 2013
Posts: 30

I write this code that you can see them
no I want passthru them in oracle database but character variable is null and cannot passthru it

can u please help me??

DECLARE Update_Query CHARACTER;
SET Update_Query='Update EMPS.UPDATE_AUTH_MP_C_ACCOUNT Set '||CARD||'='||NULL||' WHERE ACCT_NUMBER='||AccountNumber||';';

PASSTHRU(Update_Query);

dogorsy

Posted: Sun Aug 18, 2013 4:15 am Post subject: Re: Why charcater vailable value is null?

Knight

Joined: 13 Mar 2013
Posts: 553
Location: Home Office

se_zn2003 wrote:

Why is NULL ?
BECAUSE YOU ARE AN IDIOT, IGNORANT, RUDE and a disgrace. And NO, hope no one helps you. Go and get some education, not only in message broker, but also on how to relate to other colleagues.

se_zn2003

Posted: Sun Aug 18, 2013 4:52 am Post subject: Re: Why charcater vailable value is null?

Apprentice

Joined: 07 May 2013
Posts: 30

dogorsy wrote:

se_zn2003 wrote:

shut up Bastard

smdavies99

Posted: Sun Aug 18, 2013 5:32 am Post subject: Re: Why charcater vailable value is null?

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

se_zn2003 wrote:

What is the actual value of Update_Query when it is passed to the PASSTHRU function?

Have you seen what is happening with a user trace?
What is the error returned by Oracle?
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.

dogorsy

Posted: Sun Aug 18, 2013 6:08 am Post subject: Re: Why charcater vailable value is null?

Knight

Joined: 13 Mar 2013
Posts: 553
Location: Home Office

smdavies99 wrote:

se_zn2003 wrote:

What is the actual value of Update_Query when it is passed to the PASSTHRU function?

Have you seen what is happening with a user trace?
What is the error returned by Oracle?

@smdavies99 I wouldn't bother, this is the same idiot that told you to "shut up and fuck up your mouth" in the previous post.

smdavies99

Posted: Sun Aug 18, 2013 8:21 am Post subject: Re: Why charcater vailable value is null?

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

dogorsy wrote:

@smdavies99 I wouldn't bother, this is the same idiot that told you to "shut up and fuck up your mouth" in the previous post.

I was merely trying to rise above that.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.

mqsiuser

Posted: Sun Aug 18, 2013 12:53 pm Post subject: Re: Why charcater vailable value is null?

Yatiri

Joined: 15 Apr 2008
Posts: 637
Location: Germany

I would use the debugger and look at the variables view

And "Oracle SQL Developer" to test the Update-Query-String.
_________________
Just use REFERENCEs

Esa

Posted: Mon Aug 19, 2013 12:34 am Post subject: Re: Why charcater vailable value is null?

Grand Master

Joined: 22 May 2008
Posts: 1387
Location: Finland

se_zn2003 wrote:

DECLARE Update_Query CHARACTER;
SET Update_Query='Update EMPS.UPDATE_AUTH_MP_C_ACCOUNT Set '||CARD||'='||NULL||' WHERE ACCT_NUMBER='||AccountNumber||';';

PASSTHRU(Update_Query);

Please use code tags for posting code.

You are trying to access a variable called NULL...

se_zn2003

Posted: Mon Aug 19, 2013 1:18 am Post subject: Re: Why charcater vailable value is null?

Apprentice

Joined: 07 May 2013
Posts: 30

mqsiuser wrote:

I would use the debugger and look at the variables view

And "Oracle SQL Developer" to test the Update-Query-String.

Hi friends, I check it with debugger

and I find out my problem
in

Code:

update_query

variable I should set

Code:

'||CARD||'=NULL

instead of

Code:

'||CARD||'='||NULL||'

and it cause that string value is null

and I use this syntax and successfully PASSTHRU it

Code:

DECLARE Update_Query CHARACTER;
SET Update_Query='Update EMPS.UPDATE_AUTH_MP_C_ACCOUNT Set '||CARD||'=NULL WHERE ACCT_NUMBER='||AccountNumber||';';

PASSTHRU(Update_Query);

thanks for your attention[/code]

mqjeff

Posted: Mon Aug 19, 2013 6:38 am Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

So by exerting some effort to diagnose and troubleshoot, you were able to solve the problem.

se_zn2003

Posted: Mon Aug 19, 2013 8:10 am Post subject:

Apprentice

Joined: 07 May 2013
Posts: 30

mqjeff wrote:

So by exerting some effort to diagnose and troubleshoot, you were able to solve the problem.

Thanks Mr.mqjeff
I try more and hope you will be guide me for better result

McueMart

Posted: Mon Aug 19, 2013 8:21 am Post subject:

Chevalier

Joined: 29 Nov 2011
Posts: 490
Location: UK...somewhere

As an aside, I do wish that in ESQL, a concatenation of a NULL resulted in the character string 'NULL' being appended rather than it NULLing out the entire string. This is what happens in java along with most other modern languages.

Anyone know of a RFE for this, or if there is a good reason it was not done?

smdavies99

Posted: Mon Aug 19, 2013 10:00 am Post subject:

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

McueMart wrote:

You were probably never taught the art of defensive programming.

To be honest, I wasn't either but once I started trying to use ADA (circ 1978) you had to pretty quickly understand it. Now it is pretty much second nature.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.

lancelotlinc

Posted: Mon Aug 19, 2013 10:08 am Post subject:

Jedi Knight

Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA

McueMart wrote:

COALESCE is a wonderful keyword.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Why charcater vailable value is null?

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP