EZ Study

Actuarial Biology Chemistry Economics Calculators Confucius Engineer
Physics
C.S.


Common Errors collections inside Netezza/SAS running
Reserved keywords reserved in Netezza
CLI execute error: ERROR: Cannot convert 'DATE' to 'BOOL'


Question: Netezza does a fanstatic job in data process! You might say you love netezza a lot! .... Except that there is no clear/useful log information available when you have errors. They usually just tell you: ERROR: CLI execute error: Unable to retrieve error message. You have to debug those errors by yourself.

Common Error 1: CLI execute error: ERROR: Cannot convert 'DATE' to 'BOOL'

Answer: This is probably you have used multiple expressions together, e.g. when you join two datasets, if you use some condition: a.date1 lt b.date le a.date2, then you would probably get that error. In that case, you need to break that expression into two conditions: a.date1 lt b.date and b.date le a.date2.

Common Error 2: Reserved keywords reserved in Netezza, so you can't use as variables' name

Answer: Here are the keywords reserved in netezza you can't use. If you name one variable by one of the following keywords, you would probably get one of the CLI execute errors.
     _FREQ_  _NAME_  _TYPE_   
ABORT ADMIN  AND AGGREGATE  ALIGN ALL ALLOCATE ANALYSE ANALYZE ANY  AS ASC  


     
BETWEEN BINARY BIT BOTH CASE CAST CHAR CHARACTER CHECK CLUSTER COALESCE COLLATE COLLATION COLUMN CONSTRAINT COPY CROSS CURRENT CURRENT_ CURRENT_CATALOG CURRENT_DATE CURRENT_DB CURRENT_SCHEMA CURRENT_SID CURRENT_TIME CURRENT_USER CURRENT_USERID CURRENT_USEROID DEALLOCATE DEC DECIMAL DECODE DEFAULT DEFERRABLE DESC DISTINCT DISTRIBUTE DO ELSE END EXCEPT EXCLUDE EXISTS EXPLAIN EXPRESS EXTEND EXTERNAL EXTRACT FALSE FIRST FLOAT FOLLOWING FOR FOREIGN FROM FULL FUNCTION GENSTATS GLOBAL GROUP HAVING IDENTIFIER_CASE ILIKE IN INDEX INITIALLY INNER INOUT INTERSECT INTERVAL INTO LAST LEADING LEFT LIKE LIMIT LISTEN LOAD LOCAL LOCK MATERIALIZED MINUS MOVE NATURAL NCHAR NEW NOT NOTNULL NULL NULLIF NULLS NUMERIC NVL NVL2 OFF OFFSET OLD ON ONLINE ONLY OR ORDER OTHERS OUT OUTER OVER OVERLAPS PARTITION POSITION PRECEDING PRECISION PRESERVE PRIMARY RESET RESET REUSE REUSE RIGHT ROWS ROWSETLIMIT RULE SEARCH SELECT SEQUENCE SESSION_USER SETOF SHOW SOME SUBSTRING SYSTEM TABLE THEN TIES TIME TIMESTAMP TO TRAILING TRANSACTION TRIGGER TRIM TRUE UNBOUNDED UNION UNIQUE USER USING VACUUM VARCHAR VERBOSE VERSION VIEW WHEN WHERE WITH WRITE
Question: Some convenient code from Netezza Aginity workbench:
select * from _v_session where username='******'
show session verbose;
show session ;
select * from _v_database where owner='******'
select * from _v_authentication
select * from _v_connection


Related links:

Continue to : Tips to handle large datasets-I: Index and proc Datasets   SAS tutorial home
Back to: Running SAS procedures inside Netezza   Statistics tutorial home