Search results

Why am I not allowed to concatinate strings in a WHERE clause? Is this not possible? SELECT i."Inventory-Item-ID", i."Inventory-Item-Desc", 'Works' + 'Fine' + 'Here' FROM PUB."InventoryItem" AS i WHERE i."System-ID"='PP' AND i."Cust-ID"='4601' AND...

I am able to create the basic "Hello World" Stored Procedure just fine. The problem is when I try to call it. This is what I've done. Created Table @echo true; @autocommit true; CREATE TABLE PUB.HelloWorld( fld1 char(20) ); COMMIT WORK; Created Stored Procedure @echo true...