Requirement is the informix database using ODBC link run the SQL statement to execute queries and display
Envision a query button to a display window date of an input box that's all, novice can't ODBC,,
Informix database user name password are admin
SQL statements below
1
The select Amy polumbo osno, a. d. ealdate, a.f lowno, biggest lasscode [1, 2] classcode
The from gds_osaleflow a, gds_goodscode b
Where al-qeada oodscode=b.g oodscode
And a. d. ealdate='04232014'
Group by Amy polumbo osno, a. d. ealdate, a.f lowno, biggest lasscode
Into temp aaa
2
The select a.c lasscode, biggest lassname, count (*)
The from aaa a, gds_class b
Where a.c lasscode=biggest lasscode
Group by a.c lasscode, biggest lassname
The order by 1
3
Drop table aaa
In addition to write the note best,,, good learning,,, thanks a lot!!!!!!
CodePudding user response:
Somebody help me?