Datablade List Forum

Re: Exec Datablade

Posted By: Donald Payne
Date: Monday, 19 April 2004, at 4:37 p.m.

In Response To: Exec Datablade (paul@oninit.com)

This is an S/MIME signed message.

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

Hi Paul,

I don't have experience, but here's an [untested] idea: if exec_for_rows
returns a string that looks like a ROW, then you could fetch the "row"
result into a CHAR variable first, then use the REPLACE function to
SQL-escape (double) all single quotes:
REPLACE ( source_string, old_string, new_string)
something like this:

DECLARE myRow myRowType;
DECLARE execResult CHAR(1024); -- or whatever size you want

FOREACH
EXECUTE FUNCTION exec_for_rows (mySqlString)
INTO execResult
LET execResult = REPLACE (execResult, "'", "''"); -- replace every
single quote w/2 single quotes
LET myRow = execResult :: myRowType;
END FOREACH;

Slower, yes, but if it works ... ?

HTH,
- Don

Donald E. Payne -- Sr. IT Specialist
IBM, Software Group, Data Management Services, OLTP Practice
mobile office (no mail): 590 Madison Ave, New York, NY
Certified IBM Informix Professional
http://www.ibm.com/software/data

forum.subscriber@iiug.org wrote on 04/19/2004 03:41:21 PM:

> This is driving me nuts!!!
>
> If I run exec_for_rows("sqlstring") I get loads of rows and no
> errors. As soon as I use foreach into a named row type inside a chunk
> of SPL it runs for a while and then errors out with a 7607 Invalid
> Literal Row Type and drops an assert fail into the message log and the
> dbaccess session needs to be restarted.
>
> It would appear that if the exec_for_rows() returns char field contains
> a single quote (') it errors out in the assigning to the row type
>
> Cheers
> Paul
>
> --
> Paul Watson #
> Oninit Ltd # Growing old is mandatory
> Tel: +44 1436 672201 # Growing up is optional
> Fax: +44 1436 678693 #
> Mob: +44 7818 003457 #
> www.oninit.com #
>


---------z27976_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
KoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0wNDA0MTkyMDM0MzJaMCMGCSqGSIb3DQEJBDEWBBSo
3KxiRQqEH5Zu2t7fUpr6q6qLxjBDBgkqhkiG9w0BCQ8xNjA0MAcGBSsOAwIdMA4GCCqGSIb3DQMC
AgIAgDAKBggqhkiG9w0DBzANBggqhkiG9w0DAgIBKDANBgkqhkiG9w0BAQEFAASBgGtbSex9bXUZ
tljyY10EoOcz+a6lOFhoJDEvZUdAbpadQly4WySL4MTpJwW+fYS+0aongWaiH1n7QPGiA2IH0aVa
Z3cI96CRpcF0fMo51pDCHe+YV4/Lpf10PcKLyL3+tc8vHHEBsPFb+UM/ReekCtV0w2SmNVNx4fV7
B3kOt1WmAAAAAA==

---------z27976_boundary_sign--

Messages In This Thread

• Exec Datablade
  paul@oninit.com -- Monday, 19 April 2004, at 3:41 p.m.
  • Re: Exec Datablade
    Donald Payne -- Monday, 19 April 2004, at 4:37 p.m.

Datablade List Forum is maintained by Administrator with WebBBS 5.12.