RE: ROWNO & outer joins - possible bug

Marcin P wrote: > Hello, > I think I've found a bug with ROWNO in WHERE clause - > it doesn't work as expected. > Here is a sample script: > > CREATE TABLE "TALD_ADMIN"."TBLTEST_ASSETS" > ( > "REC_ID" Fixed (15,0) NOT NULL, > "INVENTORY_NO" Varchar (50) ASCII, > "IMPORT_OP_ID" Integer, > PRIMARY

AW: Unknown column name:SYSKEY

R. Vajsar wrote: > > I had sent vtrace in last but one mail message ("The error occures only > when creating a query based on VIEW: .."). > Well, once more > R.V. > I can see the command: SELECT K_P_VYVOJ.ID, K_P_VYVOJ.SYSKEY FROM APT.K_P_VYVOJ K_P_VYVOJ And as we saw in a prev

Re: AW: AW: AW: Unknown column name:SYSKEY

I had sent vtrace in last but one mail message ("The error occures only when creating a query based on VIEW: .."). Well, once more R.V. Zabach, Elke wrote: R. Vajsar wrote: Oh yes. I'm only looking for relationship between primary key, SYSKEY and error 4005 ("check if the

AW: Can't create function: General error;-4030 POS(1) Unknown schema

Rusanov wrote : > >Hello, I'm use MaxDB Version: '7.6.00.10 Build >010-121-096-895' for LINUX > > >I try create function CREATE FUNCTION LAB.AgeInInterval > > > > Error --- >Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed >General error;-4030 POS(1)

AW: Error: Invalid function result

Rusanov wrote : > >Test this is example > >CREATE TABLE TEST >( >nINT NOT NULL, >vVARCHAR(1) NOT NULL >) > >INSERT TEST (n, v) VALUES (1, '1') > >CREATE FUNCTION LAB.func_test1 >( n INT >) > >RETURNS VARCHAR > >AS > >VARvVARCHAR(1); > >BEGIN > >SELE

ROWNO & outer joins - possible bug

Hello, I think I've found a bug with ROWNO in WHERE clause - it doesn't work as expected. Here is a sample script: CREATE TABLE "TALD_ADMIN"."TBLTEST_ASSETS" ( "REC_ID" Fixed (15,0) NOT NULL, "INVENTORY_NO" Varchar (50) ASCII, "IMPORT_OP_ID" Integer, PRIMARY KEY ("REC_ID") ) // CREATE TABLE "TALD_

Re: Can't create function: General error;-4030 POS(1) Unknown schema

Try test simple example 'LAB' is my schema DROP FUNCTION LAB.test1 // CREATE FUNCTION LAB.test1 RETURNS smallint AS BEGIN return 1; END; // DROP FUNCTION LAB.test2 // CREATE FUNCTION LAB.test2 RETURNS smallint AS VAR a smallint; BEGIN IF LAB.test1() = 1 THEN return 0;

General error;-9205 POS(1) System error: AK Catalog information not found:㐀㔀　　　 　　

Hello, I'm use MaxDB Version: '7.6.00.10 Build 010-121-096-895' for LINUX By the following script I always get error DROP FUNCTION test1 // CREATE FUNCTION test1 RETURNS smallint AS BEGIN return 1; END; // DROP FUNCTION test2 // CREATE FUNCTION test2 RETURNS smallint AS VAR a smallint; BEGIN

Can't create function: General error;-4030 POS(1) Unknown schema

Hello, I'm use MaxDB Version: '7.6.00.10 Build 010-121-096-895' for LINUX I try create function CREATE FUNCTION LAB.AgeInInterval Error --- Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed General error;-4030 POS(1) Unknown schema:壬芯倀 CREATE F