Datablade List Forum

Re: drop temp tables in web blade

Posted By: Donald Payne
Date: Wednesday, 10 March 2004, at 6:20 p.m.

In Response To: drop temp tables in web blade (SIERRA TAYLOR)

This is an S/MIME signed message.

---------z62088_boundary_sign
Content-Type: text/plain; charset="US-ASCII"

Try this: set the Web Blade var MIqry2pass to "ON". Here's the doc page:


>>>>>>>>>>>>>>>>>
Two-Pass Query Processing

Use the Web DataBlade Module Administration Tool to set the following
Webdriver variable to specify that Webdriver execute a query in two parts.

Variable: MIqry2pass
Mandatory? No
Description: Specifies a query to be executed in two parts. MIqry2pass
selects an object and then executes a function. Used only in a URL.
Default is set to OFF.
<<<<<<<<<<<<<<<<

The line "Used only in a URL" is, I think, not true: above, it clearly
says you can use the Web Blade Admin Tool to set it. However, if set in
Tool, then it's global; probably a bad idea, because it hurts performance
(webdriver SELECTs the page, then does EXECUTE FUNCTION WebExplode(?,?)
passing the literal page in as a substitutable parameter).
So it is probably _better_ to put it in URL linking to the problem page,
or in a HIDDEN field in the form that submits to the problem page:

<a href="$WEB_HOME?MIval=foo&what=ever&MIqry2pass=ON">Drop your temp
tables</a>

or

<form ....>
<input type="hidden" name="MIqry2pass" value="ON">
...
</form>

HTH,
- Don

Donald E. Payne -- Sr. IT Specialist
IBM, Software Group, Data Management Services, OLTP Practice
phone / fax 1-212-745-4380 (internal 243-4380) (during day, fwds. to cust.
site, cell)
cell 631-379-2672
mobile office (no mail): 590 Madison Ave, New York, NY
Certified IBM Informix Professional
http://www.ibm.com/software/data



"SIERRA TAYLOR" <staylor@cs.uoregon.edu>
Sent by: forum.subscriber@iiug.org
03/10/2004 12:54 PM

To
datablade-list@iiug.org
cc

Subject
drop temp tables in web blade [84]






Hi All,

We just upgraged to IDS 9.4 and we're running web datablade 4.13.FC2.

With IDS version 9.3, we found that the only way to drop a temp table
created in a web blade page, was to first execute some innocuous sql (like
'set explain off' or 'insert into table1 values (null)').

Now, with version 9.4, we still can not drop the temp tables (or we can't
figure out how), but we also get errors with our fix...for example:

error message with 9.4
Dynamic Page Generation Error: Illegal SQL statement in user-defined
routine: ' drop table all_real_pubs_temp;'.

old working code in 9.3:
<?MISQL SQL="
insert into all_real_pubs_temp (zdb_id) values
(NULL);
drop table all_real_pubs_temp;">
<?/MISQL>

any ideas?
thanks a bunch,
sierra




---------z62088_boundary_sign
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature

MIAGCSqGSIb3DQEHAqCAMIIUNgIBATELMAkGBSsOAwIaBQAwCwYJKoZIhvcNAQcBoIISVjCCAtow
ggJDoAMCAQICAwMUtjANBgkqhkiG9w0BAQQFADBOMQswCQYDVQQGEwJVUzEQMA4GA1UEChMHRXF1
aWZheDEtMCsGA1UECxMkRXF1aWZheCBTZWN1cmUgQ2VydGlmaWNhdGUgQXV0aG9yaXR5MB4XDTAy
MDExNDIyMDcxMVoXDTExMTIzMTIyMDcxMVowaTELMAkGA1UEBhMCVVMxNDAyBgNVBAoTK0ludGVy
bmF0aW9uYWwgQnVzaW5lc3MgTWFjaGluZXMgQ29ycG9yYXRpb24xJDAiBgNVBAMTG0lCTSBDZXJ0
aWZpY2F0aW9uIEF1dGhvcml0eTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEA629xc49NpAPz
cAsuShTImLRYMkyepDEkC1UrPbsFRyAFZKsv3pw0MGfW/+7glzJKgPkPzlTZZfznznGbmAWVnNBQ
lyPasOtCjif603euRXReHcKfHMPLItKozibWIPHJuOnwNclOnnP2sKufuPzbTImQTTi5c8JZNZcM
J0YFzTcCAwEAAaOBqjCBpzARBglghkgBhvhCAQEEBAMCAIcwDgYDVR0PAQH/BAQDAgHGMB0GA1Ud
DgQWBBSuVA6S6qgzqSskLcfIbzDc3vNKQDAfBgNVHSMEGDAWgBRI5mj5K9KylddH2CMgEE8zmJCf
1DAPBgNVHRMBAf8EBTADAQH/MDEGA1UdJQQqMCgGCCsGAQUFBwMBBggrBgEFBQcDAgYIKwYBBQUH
AwMGCCsGAQUFBwMEMA0GCSqGSIb3DQEBBAUAA4GBADJye3NmC8q2PzypRZfu7JvDRDX1rRcanZvu
jQupk2oCScMd3FIHLE7hOfu8YffvxtLU3y8wNamQEORjTD175qAffryXypwtiVjBUKSDlBCQ14ke
McF9ViNdewEoBGiAycUq8R3Lrlf4TCDvW4GeguNTFFZnS0ygYATiJk7iDyvEMIIC2jCCAkOgAwIB
AgIDAxS2MA0GCSqGSIb3DQEBBAUAME4xCzAJBgNVBAYTAlVTMRAwDgYDVQQKEwdFcXVpZmF4MS0w
KwYDVQQLEyRFcXVpZmF4IFNlY3VyZSBDZXJ0aWZpY2F0ZSBBdXRob3JpdHkwHhcNMDIwMTE0MjIw
NzExWhcNMTExMjMxMjIwNzExWjBpMQswCQYDVQQGEwJVUzE0MDIGA1UEChMrSW50ZXJuYXRpb25h
bCBCdXNpbmVzcyBNYWNoaW5lcyBDb3Jwb3JhdGlvbjEkMCIGA1UEAxMbSUJNIENlcnRpZmljYXRp
b24gQXV0aG9yaXR5MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDrb3Fzj02kA/NwCy5KFMiY
tFgyTJ6kMSQLVSs9uwVHIAVkqy/enDQwZ9b/7uCXMkqA+Q/OVNll/OfOcZuYBZWc0FCXI9qw60KO
J/rTd65FdF4dwp8cw8si0qjOJtYg8cm46fA1yU6ec/awq5+4/NtMiZBNOLlzwlk1lwwnRgXNNwID
AQABo4GqMIGnMBEGCWCGSAGG+EIBAQQEAwIAhzAOBgNVHQ8BAf8EBAMCAcYwHQYDVR0OBBYEFK5U
DpLqqDOpKyQtx8hvMNze80pAMB8GA1UdIwQYMBaAFEjmaPkr0rKV10fYIyAQTzOYkJ/UMA8GA1Ud
EwEB/wQFMAMBAf8wMQYDVR0lBCowKAYIKwYBBQUHAwEGCCsGAQUFBwMCBggrBgEFBQcDAwYIKwYB
BQUHAwQwDQYJKoZIhvcNAQEEBQADgYEAMnJ7c2YLyrY/PKlFl+7sm8NENfWtFxqdm+6NC6mTagJJ
wx3cUgcsTuE5+7xh9+/G0tTfLzA1qZAQ5GNMPXvmoB9+vJfKnC2JWMFQpIOUEJDXiR4xwX1WI117
ASgEaIDJxSrxHcuuV/hMIO9bgZ6C41MUVmdLTKBgBOImTuIPK8QwggMgMIICiaADAgECAgQ13vTP
MA0GCSqGSIb3DQEBBQUAME4xCzAJBgNVBAYTAlVTMRAwDgYDVQQKEwdFcXVpZmF4MS0wKwYDVQQL
EyRFcXVpZmF4IFNlY3VyZSBDZXJ0aWZpY2F0ZSBBdXRob3JpdHkwHhcNOTgwODIyMTY0MTUxWhcN
MTgwODIyMTY0MTUxWjBOMQswCQYDVQQGEwJVUzEQMA4GA1UEChMHRXF1aWZheDEtMCsGA1UECxMk
RXF1aWZheCBTZWN1cmUgQ2VydGlmaWNhdGUgQXV0aG9yaXR5MIGfMA0GCSqGSIb3DQEBAQUAA4GN
ADCBiQKBgQDBXbFYZwhi7qCaLR8IbZEUaJgKHv7aBG8ThGIhw9F8zp8F4LgB8E407OKKlQRkrPFr
U18Fs8tngL9CAo7+3QEJ7OEAFE/8+/AM3UO6WyvhH4BwmRVXkxbxD5dqt8JoIxzMTVkwrFEeO68r
1u5jRXvF2V9Q0uNQDzqI578U/eDHuQIDAQABo4IBCTCCAQUwcAYDVR0fBGkwZzBloGOgYaRfMF0x
CzAJBgNVBAYTAlVTMRAwDgYDVQQKEwdFcXVpZmF4MS0wKwYDVQQLEyRFcXVpZmF4IFNlY3VyZSBD
ZXJ0aWZpY2F0ZSBBdXRob3JpdHkxDTALBgNVBAMTBENSTDEwGgYDVR0QBBMwEYEPMjAxODA4MjIx
NjQxNTFaMAsGA1UdDwQEAwIBBjAfBgNVHSMEGDAWgBRI5mj5K9KylddH2CMgEE8zmJCf1DAdBgNV
HQ4EFgQUSOZo+SvSspXXR9gjIBBPM5iQn9QwDAYDVR0TBAUwAwEB/zAaBgkqhkiG9n0HQQAEDTAL
GwVWMy4wYwMCBsAwDQYJKoZIhvcNAQEFBQADgYEAWM4p6vz33rXOArkXtYXRuePglcwlMQ0AppJu
f7aSY55QldGab+QR3mOFbpjuqP9ayNNVsmZxV97AIes9KqcjSQEEhkJ7/O5/ohZStWdn00DbOyZY
sih3Pa4Ud2HW+ipmJ6AN+qdzXOpw8ZQhZURf+vzvKWipood573nvT6wHdzgwggMgMIICiaADAgEC
AgQ13vTPMA0GCSqGSIb3DQEBBQUAME4xCzAJBgNVBAYTAlVTMRAwDgYDVQQKEwdFcXVpZmF4MS0w
KwYDVQQLEyRFcXVpZmF4IFNlY3VyZSBDZXJ0aWZpY2F0ZSBBdXRob3JpdHkwHhcNOTgwODIyMTY0
MTUxWhcNMTgwODIyMTY0MTUxWjBOMQswCQYDVQQGEwJVUzEQMA4GA1UEChMHRXF1aWZheDEtMCsG
A1UECxMkRXF1aWZheCBTZWN1cmUgQ2VydGlmaWNhdGUgQXV0aG9yaXR5MIGfMA0GCSqGSIb3DQEB
AQUAA4GNADCBiQKBgQDBXbFYZwhi7qCaLR8IbZEUaJgKHv7aBG8ThGIhw9F8zp8F4LgB8E407OKK
lQRkrPFrU18Fs8tngL9CAo7+3QEJ7OEAFE/8+/AM3UO6WyvhH4BwmRVXkxbxD5dqt8JoIxzMTVkw
rFEeO68r1u5jRXvF2V9Q0uNQDzqI578U/eDHuQIDAQABo4IBCTCCAQUwcAYDVR0fBGkwZzBloGOg
YaRfMF0xCzAJBgNVBAYTAlVTMRAwDgYDVQQKEwdFcXVpZmF4MS0wKwYDVQQLEyRFcXVpZmF4IFNl
Y3VyZSBDZXJ0aWZpY2F0ZSBBdXRob3JpdHkxDTALBgNVBAMTBENSTDEwGgYDVR0QBBMwEYEPMjAx
ODA4MjIxNjQxNTFaMAsGA1UdDwQEAwIBBjAfBgNVHSMEGDAWgBRI5mj5K9KylddH2CMgEE8zmJCf
1DAdBgNVHQ4EFgQUSOZo+SvSspXXR9gjIBBPM5iQn9QwDAYDVR0TBAUwAwEB/zAaBgkqhkiG9n0H
QQAEDTALGwVWMy4wYwMCBsAwDQYJKoZIhvcNAQEFBQADgYEAWM4p6vz33rXOArkXtYXRuePglcwl
MQ0AppJuf7aSY55QldGab+QR3mOFbpjuqP9ayNNVsmZxV97AIes9KqcjSQEEhkJ7/O5/ohZStWdn
00DbOyZYsih3Pa4Ud2HW+ipmJ6AN+qdzXOpw8ZQhZURf+vzvKWipood573nvT6wHdzgwggMlMIIC
jqADAgECAgMBFDIwDQYJKoZIhvcNAQEEBQAwaTELMAkGA1UEBhMCVVMxNDAyBgNVBAoTK0ludGVy
bmF0aW9uYWwgQnVzaW5lc3MgTWFjaGluZXMgQ29ycG9yYXRpb24xJDAiBgNVBAMTG0lCTSBDZXJ0
aWZpY2F0aW9uIEF1dGhvcml0eTAeFw0wMzExMjQxODI2NTRaFw0wNDEyMDcxODI2NTRaMIGFMQsw
CQYDVQQGEwJVUzEMMAoGA1UEChMDSUJNMREwDwYDVQQLEwhFTVBMT1lFRTEYMBYGA1UEAxMPRG9u
YWxkIEUuIFBheW5lMRkwFwYKCZImiZPyLGQBARMJNUE4NTEwODk3MSAwHgYJKoZIhvcNAQkBFhFw
YXluZWRAdXMuaWJtLmNvbTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAm8rENcZDh8vvK2tJ
KF6jTG0gWb4GEFKVanjzmUI2G+xz4K3vpmOzkWaDSRy+2dPBwvgPyOiRbUxUpkc5MV/Sw+JvQmAm
ThcjLcsFQExyOinbuRhJEbfjIyUX7VfMcHfKhhnETuMAS/i2kDkrWHtaRnhJyyOsreT6/9lfdo8y
kBkCAwEAAaOBvTCBujARBglghkgBhvhCAQEEBAMCBaAwDgYDVR0PAQH/BAQDAgXgMB0GA1UdDgQW
BBQ/fh5x0wzpWEXd7SMDQ0u2PRkWxjAsBgNVHREEJTAjoCEGCisGAQQBgjcUAgOgEwwRcGF5bmVk
QHVzLmlibS5jb20wHwYDVR0jBBgwFoAUrlQOkuqoM6krJC3HyG8w3N7zSkAwJwYDVR0lBCAwHgYI
KwYBBQUHAwIGCCsGAQUFBwMDBggrBgEFBQcDBDANBgkqhkiG9w0BAQQFAAOBgQCTqqC2OdEUtbFy
Ahi6RlOrPwKt5+pcOe30y8Ze+ue7XOL95aVi5ACUuvL2vwnfmO+6M2kkFwqxKSA6PnCv6c7J8G7q
ERBA36GMIzhM+nlxhqVotknT1BNYn/Ui9U8kLTN9hj4LmiTGmNnt+j5qWnvGkC6oEZ2WWYgfzoNm
SZqmTTCCAyUwggKOoAMCAQICAwEUMjANBgkqhkiG9w0BAQQFADBpMQswCQYDVQQGEwJVUzE0MDIG
A1UEChMrSW50ZXJuYXRpb25hbCBCdXNpbmVzcyBNYWNoaW5lcyBDb3Jwb3JhdGlvbjEkMCIGA1UE
AxMbSUJNIENlcnRpZmljYXRpb24gQXV0aG9yaXR5MB4XDTAzMTEyNDE4MjY1NFoXDTA0MTIwNzE4
MjY1NFowgYUxCzAJBgNVBAYTAlVTMQwwCgYDVQQKEwNJQk0xETAPBgNVBAsTCEVNUExPWUVFMRgw
FgYDVQQDEw9Eb25hbGQgRS4gUGF5bmUxGTAXBgoJkiaJk/IsZAEBEwk1QTg1MTA4OTcxIDAeBgkq
hkiG9w0BCQEWEXBheW5lZEB1cy5pYm0uY29tMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCb
ysQ1xkOHy+8ra0koXqNMbSBZvgYQUpVqePOZQjYb7HPgre+mY7ORZoNJHL7Z08HC+A/I6JFtTFSm
RzkxX9LD4m9CYCZOFyMtywVATHI6Kdu5GEkRt+MjJRftV8xwd8qGGcRO4wBL+LaQOStYe1pGeEnL
I6yt5Pr/2V92jzKQGQIDAQABo4G9MIG6MBEGCWCGSAGG+EIBAQQEAwIFoDAOBgNVHQ8BAf8EBAMC
BeAwHQYDVR0OBBYEFD9+HnHTDOlYRd3tIwNDS7Y9GRbGMCwGA1UdEQQlMCOgIQYKKwYBBAGCNxQC
A6ATDBFwYXluZWRAdXMuaWJtLmNvbTAfBgNVHSMEGDAWgBSuVA6S6qgzqSskLcfIbzDc3vNKQDAn
BgNVHSUEIDAeBggrBgEFBQcDAgYIKwYBBQUHAwMGCCsGAQUFBwMEMA0GCSqGSIb3DQEBBAUAA4GB
AJOqoLY50RS1sXICGLpGU6s/Aq3n6lw57fTLxl7657tc4v3lpWLkAJS68va/Cd+Y77ozaSQXCrEp
IDo+cK/pzsnwbuoREEDfoYwjOEz6eXGGpWi2SdPUE1if9SL1TyQtM32GPguaJMaY2e36Pmpae8aQ
LqgRnZZZiB/Og2ZJmqZNMYIBuzCCAbcCAQEwcDBpMQswCQYDVQQGEwJVUzE0MDIGA1UEChMrSW50
ZXJuYXRpb25hbCBCdXNpbmVzcyBNYWNoaW5lcyBDb3Jwb3JhdGlvbjEkMCIGA1UEAxMbSUJNIENl
cnRpZmljYXRpb24gQXV0aG9yaXR5AgMBFDIwCQYFKw4DAhoFAKCBojAYBgkqhkiG9w0BCQMxCwYJ
KoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0wNDAzMTAyMzE5MzlaMCMGCSqGSIb3DQEJBDEWBBRj
Mc3e4gpHYw1arMUthMDd56ywyTBDBgkqhkiG9w0BCQ8xNjA0MAcGBSsOAwIdMA4GCCqGSIb3DQMC
AgIAgDAKBggqhkiG9w0DBzANBggqhkiG9w0DAgIBKDANBgkqhkiG9w0BAQEFAASBgFDXkRshBtT0
JPwD5LFZh5YwHNqR9QVuE0UmjkVtpAi4882MuqGNh7M9KAueGHQgvSOOopAlHhsGhJQDiP8pOwkk
jIn/x+myvUSk4TDbBV7SlyjJjxEVvdQiFBMXuu8KNyGpBs8FqmoWJtyTe0e2sWq7yhFneNtg5IHR
XmOv0t1hAAAAAA==

---------z62088_boundary_sign--

Messages In This Thread

• drop temp tables in web blade
  SIERRA TAYLOR -- Wednesday, 10 March 2004, at 12:54 p.m.
  • Re: drop temp tables in web blade
    Donald Payne -- Wednesday, 10 March 2004, at 6:20 p.m.

Datablade List Forum is maintained by Administrator with WebBBS 5.12.