In MS SQL, I can create a new SQL table in a select statement:
SELECT INTO NEW_TABLE
from EXISTING TABLE
WHERE FIELD_1 = 'A'
MS SQL Dynamically creates the table with whatever fields are selected, giving them the same attributes.
I find it helpful to quickly...
No content found
Please log in to your account to view your subscribed posts.
| Directory | Topics | Posts | Last Post | |||
|---|---|---|---|---|---|---|
| Tips, Techniques, Tools & Announcements | ||||||
|
Open forum to post Events
Topics: 21
Posts: 96
Last Post:
RDI 9.6.0.8 has been released.
|
21 | 96 |
|
|||
|
Lists of other websites related to coding on the Iseries.
Topics: 90
Posts: 351
Last Post:
Why Programming Extended Team
|
90 | 351 |
|
|||
|
Links/Reviews of products on the AS400
market. Some may contain free trial versions. If you see something you have worked with please post your thoughts.
Topics: 255
Posts: 951
Last Post:
CGIDEV2 and MS WORD dynamic documents
|
255 | 951 |
|
|||
|
Enter/View Iseries Tips Techniques and Tricks.
Topics: 284
Posts: 1,420
Last Post:
Import various spreadsheets with JS-XLSX
|
284 | 1,420 |
|
|||
| Iseries Programming Languages | ||||||
|
We enjoy helping NEWBIES learn what has been so good to us over the past ..Oh 100 years or so... So feel free to post any/all BASIC questions to this forum.
Topics: 438
Posts: 3,198
|
438 | 3,198 |
|
|||
|
RPG/RPGLE Code Forum
Topics: 4,404
Posts: 28,656
|
4,404 | 28,656 |
|
|||
|
command line and embedded sql
Topics: 1,784
Posts: 10,896
Last Post:
Create File-Table "On-the-Fly" ?
|
1,784 | 10,896 |
|
|||
|
CLP/CLLE Code Forum
Topics: 1,107
Posts: 6,709
|
1,107 | 6,709 |
|
|||
|
subfiles,screens, physical files, logicals, print files and menus
Topics: 738
Posts: 4,089
Last Post:
Retrieve CHRID of a spoolfile.
|
738 | 4,089 |
|
|||
|
COmmon Business-Oriented Language.
Topics: 148
Posts: 656
Last Post:
OVRPRTF in COBOL
|
148 | 656 |
|
|||
|
RPG commands and functions show with
their PHP equivalents ....
A great resource would be
directly from the horses mouth...
http://php.net/
Topics: 94
Posts: 491
|
94 | 491 |
|
|||
|
Anything to do with AS400/Iseries reports.
Topics: 325
Posts: 1,861
Last Post:
Create additional pages in Excel workbook
|
325 | 1,861 |
|
|||
|
Whatever crosses your mind.
Topics: 1,413
Posts: 7,764
Last Post:
Changing current user profile
|
1,413 | 7,764 |
|
|||
|
Anything dealing with IFS
Topics: 325
Posts: 1,893
|
325 | 1,893 | ||||
|
Anything that deals with system administration.
Topics: 969
Posts: 4,981
|
969 | 4,981 |
|
|||
|
Sub-Forums:
| ||||||
|
general questions about the database.
Topics: 208
Posts: 1,010
|
208 | 1,010 |
Performance of table operations with a row change timestamp column?
by ryanweeks
January 28th, 2020, 08:29 AM
|
|||
|
Free format examples
Topics: 160
Posts: 1,139
Last Post:
EXTNAME in SQLRPGLE
|
160 | 1,139 |
|
|||
|
JAVA coding forum
Topics: 242
Posts: 1,111
Last Post:
Calling JAVA methods with varargs from RPG
|
242 | 1,111 |
|
|||
|
web development using HTTP on the Iseries
Topics: 161
Posts: 778
|
161 | 778 |
AxisC failing for any request. Request failes with GSKit error?
by Luigi Brito
April 19th, 2020, 01:29 PM
|
|||
|
Any questions relating more to a PC type environment. This could be PC, Servers (both LINUX and WINDOWS)
Topics: 224
Posts: 1,180
Last Post:
Auto insert from EXCEL to AS400
|
224 | 1,180 |
|
|||
| ChangefIT/DeployfIT/DeskfIT/XrefIT | ||||||
|
Any news eminating from EcofIT regarding DeskfIT, ChangefIT, or XrefIT. These may be cross-posted to/from support.changefit.com
Topics: 70
Posts: 117
Last Post:
DeskfIT v2.02 released
|
70 | 117 |
|
|||
|
Any general questions about DeskfIT, ChangefIT, or XrefIT may be posted here. These may be cross-posted to/from support.changefit.com
Topics: 14
Posts: 57
|
14 | 57 |
ChangefIT versus Turnover - Has anyone got any comparison notes?
by DeadManWalks
June 10th, 2015, 01:43 PM
|
|||
| RDP/RDi/WDSC | ||||||
|
Show us what youve learned. Teach us old dogs some new tricks..
Topics: 200
Posts: 1,023
Last Post:
Are the updates to RDI 9.6 cumulative?
|
200 | 1,023 |
|
|||
| Job Postings | ||||||
|
Please place all job related posts here. Job posting that are not posted to this forum will be deleted.
Topics: 78
Posts: 220
Last Post:
Junior RPG Programmer Opportunities
|
78 | 220 |
|
|||
| OFF Topic | ||||||
|
Just about anything is game here!
Topics: 831
Posts: 6,016
|
831 | 6,016 | ||||
-
2 days ago
-
I'm looking at Flutter to start with. But I'm curious what you guys jump to closest to RPGLE. I've read java in another thread2 days ago
-
Hello all!
I'm creating a program that allows a user to enter an account number (the account number length varies) and then have the program return a concatenated string of email addresses that are associated with the aforementioned account number. Whenever I CALL FOECADDRPG PARM('38539')...4 days ago -
Hey Everybody!
I was hoping someone might be able to figure out what is going wrong with my Parameter (Dcl-PI) list below. The program is by no means done but, in it's current state, the error below hinders me from moving forward. The code under the title "Plist" are the respective...5 days ago -
Are the updates to RDI 9.6 cumulative or do I have to install RDI 9.6.0.1, 9.6.0.2,...., 9.6.0.8 one by one?
What I'm thinking about is that after installing RDI 9.6 core, is it enough to install 9.6.0.8 to have all
previous updates installed?
I haven't found anything about...5 days ago