System i Navigator Run SQL Script block CL commands
Hello. The run sql script in System i Navigator allows me to run CL commands. How can i block this? Thx in advance.

Answer Question   |  October 19, 2012  11:53 AM
CL command, IBM, iNavigator, Sql Script

Translate Ruby Script to SQL Query?
I need help translating a ruby script to SQL query. I’m a SQL noob. Help please. [em]here is the script.[/em] require “rubygems” require “ruport” SQL = <<-EOS SELECT     tv.ApptDate, tv.PatName, tv.PatFirst, tv.PatLast, tv.Phone, tv.ApptTime, tv.Provlast, tv.ProvFirst, tv.ProvTitle, tv.Clinic, tv.Age, tv.Notes FROM (  /* SECOND LEVEL, this brings out cliniccode from the main query so we [...]

Answer Question   |  September 22, 2010  2:19 PM
Ruby, SQL Query, SQL Query Parse Data, Sql Script, SQL Server 2000

Query Calculation Part of Select Criteria
This query works great except I need to add one thing. There are two district codes that need to be included in the query. These codes just need the MC_Tax_Amount field totaled – no dividing by two. How do I add this to my query? Thank you, SELECT “T16.CPRP”.CP_DISTRICT_CODE, SUM(“T16.CMCL”.MC_TAX_AMOUNT/2) AS TOWN , SUM(“T16.CMCL”.MC_TAX_AMOUNT/2) AS [...]

Answer Question   |  January 29, 2010  3:00 PM
iSeries Navigator, Query Calculation, SQL, Sql Script

Multiple Tables to Bulk Import .sql script
I am a very new user to both SQL and Oracle and I am hoping that someone can explain to me if there is a way to multiple tables in a schema to .sql Import scripts. I know that in TOAD, you can right click on a table and choose export from the list, then [...]

Answer Question   |  April 22, 2009  9:30 PM
Oracle, Oracle import/export, Oracle Table Export, SQL, Sql Script, TOAD