| Author |
Message
|
| mqsiuser |
 Posted: Sun Aug 18, 2013 1:58 am Post subject: Re: how can i delete row from share value |
 |
|
Yatiri
Joined: 15 Apr 2008
Posts: 637
Location: Germany
|
When I started with Broker it was new at one time to me (to assign NULL to delete data)
Sometimes I search on mqseries for things and the answer just is "dude, bla bla"
That's anoying. More than impolite people.
_________________
Just use REFERENCEs |
|
| Back to top |
|
 |
| se_zn2003 |
| Posted: Mon Aug 19, 2013 1:25 am Post subject: Re: how can i delete row from share value |
|
|
Apprentice
Joined: 07 May 2013
Posts: 30
|
| mqsiuser wrote: |
When I started with Broker it was new at one time to me (to assign NULL to delete data)
Sometimes I search on mqseries for things and the answer just is "dude, bla bla"
That's anoying. More than impolite people. |
dude, bla bla  |
|
| Back to top |
|
|
| se_zn2003 |
| Posted: Mon Aug 19, 2013 1:29 am Post subject: |
|
|
Apprentice
Joined: 07 May 2013
Posts: 30
|
Hi guys
I find out my problem and successfully delete row of data from share variable
Thanks for Your helping !!!!!!!!!!!  |
|
| Back to top |
|
|
| mqsiuser |
| Posted: Mon Aug 19, 2013 2:47 am Post subject: Re: how can i delete row from share value |
|
|
Yatiri
Joined: 15 Apr 2008
Posts: 637
Location: Germany
|
You are really strange, be more careful with how you communicate!
How did you solve it?
_________________
Just use REFERENCEs |
|
| Back to top |
|
|
| se_zn2003 |
| Posted: Mon Aug 19, 2013 3:42 am Post subject: Re: how can i delete row from share value |
|
|
Apprentice
Joined: 07 May 2013
Posts: 30
|
| mqsiuser wrote: |
You are really strange, be more careful with how you communicate!
How did you solve it? |
did you want that I write the correct syntax?? |
|
| Back to top |
|
|
| mqsiuser |
| Posted: Mon Aug 19, 2013 3:45 am Post subject: Re: how can i delete row from share value |
|
|
Yatiri
Joined: 15 Apr 2008
Posts: 637
Location: Germany
|
| se_zn2003 wrote: |
| mqsiuser wrote: |
You are really strange, be more careful with how you communicate!
How did you solve it? |
did you want that I write the correct syntax?? |
ofc (of course!)
_________________
Just use REFERENCEs |
|
| Back to top |
|
|
| se_zn2003 |
| Posted: Mon Aug 19, 2013 3:57 am Post subject: Re: how can i delete row from share value |
|
|
Apprentice
Joined: 07 May 2013
Posts: 30
|
| lancelotlinc wrote: |
| se_zn2003 wrote: |
| would you please write the correct syntax in ESQL base |
So, you are asking us to do your work for you? Are you getting paid for this work? Do you wish to share some of your payment with us? |
it's my duty the help any body if I can solve their problem and never send comments as "So, you are asking us to do your work for you? Are you getting paid for this work? Do you wish to share some of your payment with us?" like Mr.lancelotlinc for another user !!!!
so I send correct syntax to this forums to use them when "anybody" having problem about it.
| Code: |
DECLARE Var_LiveSessionMP SHARED ROW;
DECLARE Cursor_cnt INTEGER 0;
DELETE FIELD Var_LiveSessionMP.Root[Cursor_cnt]; |
 |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Mon Aug 19, 2013 3:59 am Post subject: Re: how can i delete row from share value |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| se_zn2003 wrote: |
| lancelotlinc wrote: |
| se_zn2003 wrote: |
| would you please write the correct syntax in ESQL base |
So, you are asking us to do your work for you? Are you getting paid for this work? Do you wish to share some of your payment with us? |
it's my duty the help any body if I can solve their problem and never send comments as "So, you are asking us to do your work for you? Are you getting paid for this work? Do you wish to share some of your payment with us?" like Mr.lancelotlinc for another user !!!!
|
Your vulgarity is not welcome here. Use of cursing is not an accepted form of communication here.
If you communicate on a professional level in a courteous way, you may continue to post.
We do not do your work for you. You are expected to do your own work.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| se_zn2003 |
| Posted: Mon Aug 19, 2013 4:09 am Post subject: Re: how can i delete row from share value |
|
|
Apprentice
Joined: 07 May 2013
Posts: 30
|
| lancelotlinc wrote: |
| se_zn2003 wrote: |
| lancelotlinc wrote: |
| se_zn2003 wrote: |
| would you please write the correct syntax in ESQL base |
So, you are asking us to do your work for you? Are you getting paid for this work? Do you wish to share some of your payment with us? |
it's my duty the help any body if I can solve their problem and never send comments as "So, you are asking us to do your work for you? Are you getting paid for this work? Do you wish to share some of your payment with us?" like Mr.lancelotlinc for another user !!!!
|
Your vulgarity is not welcome here. Use of cursing is not an accepted form of communication here.
If you communicate on a professional level in a courteous way, you may continue to post.
We do not do your work for you. You are expected to do your own work. |
I think communicate in a courteous way and I never cursing any body
but your answer is not suitable friend!!! |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Mon Aug 19, 2013 4:20 am Post subject: Re: how can i delete row from share value |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| se_zn2003 wrote: |
| lancelotlinc wrote: |
| se_zn2003 wrote: |
| lancelotlinc wrote: |
| se_zn2003 wrote: |
| would you please write the correct syntax in ESQL base |
So, you are asking us to do your work for you? Are you getting paid for this work? Do you wish to share some of your payment with us? |
it's my duty the help any body if I can solve their problem and never send comments as "So, you are asking us to do your work for you? Are you getting paid for this work? Do you wish to share some of your payment with us?" like Mr.lancelotlinc for another user !!!!
|
Your vulgarity is not welcome here. Use of cursing is not an accepted form of communication here.
If you communicate on a professional level in a courteous way, you may continue to post.
We do not do your work for you. You are expected to do your own work. |
I think communicate in a courteous way and I never cursing any body
but your answer is not suitable friend!!! |
So this is an example of your courteous communication?
http://www.mqseries.net/phpBB2/viewtopic.php?t=65122
| se_zn2003 wrote: |
| dogorsy wrote: |
| se_zn2003 wrote: |
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); |
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. |
shut up Bastard |
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| se_zn2003 |
| Posted: Mon Aug 19, 2013 4:27 am Post subject: Re: how can i delete row from share value |
|
|
Apprentice
Joined: 07 May 2013
Posts: 30
|
| lancelotlinc wrote: |
| se_zn2003 wrote: |
| lancelotlinc wrote: |
| se_zn2003 wrote: |
| lancelotlinc wrote: |
| se_zn2003 wrote: |
| would you please write the correct syntax in ESQL base |
So, you are asking us to do your work for you? Are you getting paid for this work? Do you wish to share some of your payment with us? |
it's my duty the help any body if I can solve their problem and never send comments as "So, you are asking us to do your work for you? Are you getting paid for this work? Do you wish to share some of your payment with us?" like Mr.lancelotlinc for another user !!!!
|
Your vulgarity is not welcome here. Use of cursing is not an accepted form of communication here.
If you communicate on a professional level in a courteous way, you may continue to post.
We do not do your work for you. You are expected to do your own work. |
I think communicate in a courteous way and I never cursing any body
but your answer is not suitable friend!!! |
So this is an example of your courteous communication?
http://www.mqseries.net/phpBB2/viewtopic.php?t=65122
| se_zn2003 wrote: |
| dogorsy wrote: |
| se_zn2003 wrote: |
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); |
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. |
shut up Bastard |
|
Excuse me buddy   |
|
| Back to top |
|
|
| Vitor |
| Posted: Mon Aug 19, 2013 5:08 am Post subject: Re: how can i delete row from share value |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| se_zn2003 wrote: |
| Excuse me buddy |
We're not your buddies. We're professionals. Further examples of this will be moderated. Your use of the f word has been passed to the board administror (as it should have been contact admin) with my recommendation of what they should do about you.
@dogorsy - Likewise. If you have an issue with a post, ask for moderation.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| rekarm01 |
| Posted: Mon Aug 19, 2013 9:00 am Post subject: Re: how can i delete row from share value |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 1415
|
| mqsiuser wrote: |
| SET Environment.variables.myData = NULL; |
Although being sloppy with upper-case vs. lower-case can cause other problems ... |
|
| Back to top |
|
|
| mqsiuser |
| Posted: Mon Aug 19, 2013 2:11 pm Post subject: Re: how can i delete row from share value |
|
|
Yatiri
Joined: 15 Apr 2008
Posts: 637
Location: Germany
|
| rekarm01 wrote: |
| mqsiuser wrote: |
| SET Environment.variables.myData = NULL; |
Although being sloppy with upper-case vs. lower-case can cause other problems ... |
sorry. It is Variables with a capital v ?!
_________________
Just use REFERENCEs |
|
| Back to top |
|
|
|
|
