| Author |
Message
|
| pepperpaddy |
 Posted: Thu Jul 03, 2003 12:33 am Post subject: ESQL Editor |
 |
|
Novice
Joined: 09 May 2003
Posts: 17
|
Hi
Does anyone know of an ESQL Editor. We are on WMQI 2.1 but aren't moving to V5 anytime soon.
Thanks |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Thu Jul 03, 2003 5:57 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You mean, something that knows about the syntax of ESQL and the available library of functions, that isn't the Control Center?
There isn't one, to the best of my knowledge. It's not hard, although it is a bit time consuming, to educate a decent programming editor about the syntax and keywords of ESQL, so that you get at least some assistance. |
|
| Back to top |
|
|
| Tibor |
| Posted: Thu Jul 03, 2003 6:28 am Post subject: |
|
|
Grand Master
Joined: 20 May 2001
Posts: 1033
Location: Hungary
|
We are working with UltraEdit and if you need a syntax coloring for this editor I can send you.
Tibor |
|
| Back to top |
|
|
| pepperpaddy |
| Posted: Fri Jul 04, 2003 12:43 am Post subject: |
|
|
Novice
Joined: 09 May 2003
Posts: 17
|
Thanx Tibor 
I should be able to get a copy of UltraEdit could you send me the syntax coloring? |
|
| Back to top |
|
|
| j1 |
| Posted: Fri Jul 18, 2003 10:35 am Post subject: ESQL Editor |
|
|
Centurion
Joined: 23 Jun 2003
Posts: 139
|
| Could someone pls tell me where to get Ultraedit and the syntax coloring... |
|
| Back to top |
|
|
| pepperpaddy |
| Posted: Mon Jul 21, 2003 1:00 am Post subject: |
|
|
Novice
Joined: 09 May 2003
Posts: 17
|
| You should be able to buy UltraEdit from their web site www.ultraedit.com Not sure how much it costs. |
|
| Back to top |
|
|
| Tibor |
| Posted: Mon Jul 21, 2003 5:45 am Post subject: |
|
|
Grand Master
Joined: 20 May 2001
Posts: 1033
Location: Hungary
|
This is not an official  and maybe not a perfect but works:
| Code: |
/L10"WMQI ESQL" Line Comment = -- Block Comment On = /* Block Comment Off = */ String Chars = ' File Extensions = SQL ESQL
/Delimiters = .~!%@^&*()-+=|\/{}[]:;"'<> , ?
/Function String = "%*function ^(*^) "
/Function String 1 = "%*procedure ^(*^) "
/Indent Strings = "then" "do"
/Unindent Strings = "end" "end if" "end while"
/C1"Keywords"
AFTER ALL AND ANY AS ATTACH
BEFORE BEGIN BETWEEN BOTH BY
CASE CCSID COLUMN COMMENT COMPOUND CONTINUE CREATE
DECLARE DEFAULT DELETE DETACH DISABLE DISTINCT DO DOMAIN
EACH ELSE ENABLE ENCODING END ESCAPE EVAL EXCEPTION EXCLUSIVE EXISTS
FALSE FIELD FIRSTCHILD FOR FROM FUNCTION
GO GROUP GROUPS
HAVING
IF IN INSERT INTO IS ITEM
LASTCHILD LEADING LIKE LIST
MESSAGE MOVE
NAME NEXT NEXTSIBLING NOT NULL NUMERIC
OF ON OR ORDER OUT
PARENT PARSE PASSTHRU PLACING PREVIOUSSIBLING PROPAGATE
REFERENCES REFERENCING REPEAT RETURN RETURNS ROW ROWS
SELECT SEQUENCE SET SEVERITY
TABLE THE THEN THREAD THROW TIME TO TRAILING TRUE TRUNCATE TYPE
UNDER UNION UNIQUE UNTIL UPDATE USER
VALUE VALUES
WHEN WHERE WHILE WITH
/C2"Functions"
ABS AVG
BITAND BITNOT BITOR BITSTREAM BITXOR
CARDINALITY CAST CEIL COALESCE COUNT CURRENT_DATE CURRENT_GMTDATE CURRENT_GMTTIME CURRENT_GMTTIMESTAMP CURRENT_TIME CURRENT_TIMESTAMP
DECODE DEREF DUMP
EXTRACT
FIELDNAME FIELDTYPE FLOOR
INITCAP INSTR INSTRB
LASTMOVE LENGTH LOCAL_TIMEZONE LOWER LTRIM
MAX MIN MOD
NULLIF
OVERLAY
POSITION
ROUND RTRIM
SAMEFIELD SQRT SUBSTRING SUM
TRIM TRUNCATE
UPPER UCASE UUIDASBLOB UUIDASCHAR
VARIANCE VSIZE
/C3"Correlation names/Parsers"
Body
DestinationList
Environment ExceptionList
InputBody InputDestinationList InputExceptionList InputLocalEnvironment InputProperties InputRoot
JMS
LocalEnvironment
MQCIH MQDLH MQIIH MQMD MQMDE MQPCF MQRFH MQRFH2 MQRMH MQSAPH MQWIH SMQ_BMH MRM
NEON NEONMSG
OutputDestinationList OutputExceptionList OutputLocalEnvironment OutputRoot
Properties
Root
XML
/C4"Datatypes/Constants"
BIT BLOB BOOLEAN
CHAR CHARACTER
DATE DAY DECIMAL
FLOAT
HOUR
GMTTIME GMTTIMESTAMP
INT INTEGER INTERVAL
MINUTE MONTH
REFERENCE
SECOND SQLCODE SQLERRORTEXT SQLNATIVEERROR SQLSTATE
TIME TIMESTAMP
YEAR
|
|
|
| Back to top |
|
|
|
|
