SQP file members
Does SQL on AS400/iSeries allow selecting a specific member to be prcesssed without using a OVRDBF command?
View Answer
| Aug 26 2008 4:04 PM GMT
| asked by
DMinNC
SQL, OVRDBF, AS/400 and SQL
SQL/400 commands
Hi friends, How can I see or get the SQL/400 commands executed from another user ?Regards,Roberto
View Answer
| Aug 12 2008 0:46 AM GMT
| asked by
SILVARB
SQL/400, AS/400 and SQL
Multiple SQL For (AS/400)
For (AS/400) I need to create a source member with multiple sentences of sql:i.e.update aa....update bb....update cc...., and then run these source member with runsqlstm.Is it possible? which is the character to separate between sentences? Thanks in advance
View Answer
| Jul 24 2008 7:42 PM GMT
| asked by
WSCST
SQL Server administration, AS/400 and SQL
Is there a way to partial field (or substring) a DESCR254_MIXED (long character field) in a SQL statement?
Is there a way to partial field (or substring) a DESCR254_MIXED (long character field) in a SQL statement?Have tried the following, which do not work: column descr254_mixed format A30 set wrap off select descr254_mixed from PS REQ_LINESELECT left(descr254_mixed, 20) from PS_REQ_LINE
View Answer
| Jun 9 2008 4:50 PM GMT
| asked by
SQL Server Ask the Experts
SQL, SQL statements, AS/400 and SQL
SQL In CL/400
Could it possibleto write SQL in CL/400 Programing?
View Answer
| Apr 28 2008 7:11 AM GMT
| asked by
VENKYAS400
CL/400, AS/400 and SQL, CL
