Simple question.
--openmail-part-000567c8-00000001
Content-Type: text/plain; charset=US-ASCII
Content-Disposition: inline; filename="BDY.TXT"
;Creation-Date="Tue, 23 May 2000 11:59:26 -0500"
Content-Transfer-Encoding: 7bit
Can you use the || operator in a insert statement I keep getting syntax
errors? It works fine in an update.
Here is what I am trying
insert into temp_table(char_col) values("a" || "b");
I have IDS 7.30.UC10 on redhat 6.0
Bryan Sapot
Lawless Technology Inc.
bsapot@lawless-tech.com
--openmail-part-000567c8-00000001
Content-Type: application/ms-tnef
Content-Disposition: attachment; filename="WINMAIL.DAT"
Content-Transfer-Encoding: base64
eJ8+IkKhAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5N
aWNyb3NvZnQgTWFpbC5Ob3RlAAAxAQ2ABAACAAAAAgAAAgEDkAYADAAAAAEAAAADABcAAQAA
AAEbAQOQBgAMAAAAAQAAAAMANgAAAAAAATkBBIABABEAAABTaW1wbGUgcXVlc3Rpb24uAAAw
AQOQBgAQAAAAAQAAAEAAOQDgWiGC18S/AQGxAQOQBgAMAAAAAQAAAAMA3j+vbwAAAT4BA5AG
AAwAAAABAAAAAwAJWQEAAAABZgEDkAYADAAAAAEAAAALAAIAAQAAAAEOAQOQBgAoAAAAAQAA
AAIBcQABAAAAFgAAAAG/xNeCB4We38EwnBHUjdEACMc3a+8AAAKgAQOQBgAkAAAAAQAAAB4A
cAABAAAAEQAAAFNpbXBsZSBxdWVzdGlvbi4AAAAAAs8BA5AGABQAAAABAAAAHgA9AAEAAAAB
AAAAAAAAAAJcAQOQBgAsAAAAAQAAAB4A74EIIAYAAAAAAMAAAAAAAABGAAAAADiFAAABAAAA
AQAAAAAAAAACgAEDkAYALAAAAAEAAAAeAPCBCCAGAAAAAADAAAAAAAAARgAAAAA3hQAAAQAA
AAEAAAAAAAAAAoABA5AGACwAAAABAAAAHgDxgQggBgAAAAAAwAAAAAAAAEYAAAAANoUAAAEA
AAABAAAAAAAAAAKAAQOQBgAkAAAAAQAAAAMA8oEIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAA
AAAAAUcBA5AGACQAAAABAAAAAwDzgQggBgAAAAAAwAAAAAAAAEYAAAAAEYUAAAAAAAABQQED
kAYAJAAAAAEAAAADAPSBCCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAFBAQOQBgAkAAAA
AQAAAAsA9YEIIAYAAAAAAMAAAAAAAABGAAAAAA6FAAAAAAAAAUgBA5AGACQAAAABAAAAAwD2
gQggBgAAAAAAwAAAAAAAAEYAAAAAAYUAAAAAAAABNAEDkAYAJAAAAAEAAAALAPeBCCAGAAAA
AADAAAAAAAAARgAAAAAGhQAAAAAAAAFCAQOQBgAsAAAAAQAAAB4A+IEIIAYAAAAAAMAAAAAA
AABGAAAAAFSFAAABAAAABAAAADkuMAACPwEDkAYAJAAAAAEAAAADAPmBCCAGAAAAAADAAAAA
AAAARgAAAABShQAAJ2oBAAEaAQOQBgAgAAAAAQAAAAIBCzABAAAAEAAAAK/fnoWcMNQRjdEA
CMc3a+8CbgEDkAYADAAAAAEAAAADAIAQ/////wGPAQkABAACAAAAAAAAAAEDkAYADAAAAAEA
AAALACMAAAAAAAEuAQOQBgAMAAAAAQAAAAsAKQAAAAAAATQBBJAGAFgCAAABAAAAEwAAAB4A
ATABAAAAGQAAACdpbmZvcm1peC1saXN0QGlpdWcub3JnJwAAAAACAf8PAQAAAEsAAAAAAAAA
gSsfpL6jEBmdbgDdAQ9UAgAAAQBpbmZvcm1peC1saXN0QGlpdWcub3JnAFNNVFAAaW5mb3Jt
aXgtbGlzdEBpaXVnLm9yZwAAAwAVDAEAAAADAAAwAAAAAB4AAjABAAAABQAAAFNNVFAAAAAA
HgAaDAEAAAAIAAAAYnNhcG90AAACARkMAQAAADMAAAAAAAAAjVVM0Ow8Ec6B/wgACbEDegEA
AAALAAAAAAAAADEdYnNhcG90HjUdTGF3bGVzcwAAAwBxOgAAAAALAEA6AAAAAAMAADkAAAAA
AgELMAEAAAAcAAAAU01UUDpJTkZPUk1JWC1MSVNUQElJVUcuT1JHAAIB+Q8BAAAASwAAAAAA
AACBKx+kvqMQGZ1uAN0BD1QCAAABEGluZm9ybWl4LWxpc3RAaWl1Zy5vcmcAU01UUABpbmZv
cm1peC1saXN0QGlpdWcub3JnAAADAP4PBgAAAB4AAzABAAAAFwAAAGluZm9ybWl4LWxpc3RA
aWl1Zy5vcmcAAAMA/18AAAAAAwD9XwEAAAAeAPZfAQAAABcAAABpbmZvcm1peC1saXN0QGlp
dWcub3JnAAACAfdfAQAAAEsAAAAAAAAAgSsfpL6jEBmdbgDdAQ9UAgAAAQBpbmZvcm1peC1s
aXN0QGlpdWcub3JnAFNNVFAAaW5mb3JtaXgtbGlzdEBpaXVnLm9yZwAACwAPDgAABICHiQ==
--openmail-part-000567c8-00000001--
bsapot@sapot.com wrote:
Please do not post MIME or HTML to CDI.
> Can you use the || operator in a insert statement I keep getting syntax
> errors? It works fine in an update.
You can indirectly:
> Here is what I am trying
> insert into temp_table(char_col) values("a" || "b");Try:
INSERT INTO temp_table(char_col) VALUES ( (
SELECT "a"||"b" FROM systables WHERE tabid = 1)
);
> I have IDS 7.30.UC10 on redhat 6.0
Art S. Kagel