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 make a result table when troubleshooting, or testing/designing something pre-production.
Is there an equivalent in IBMi SQL and/or through Navigator SQL ?
Or do I have to spec it out through DDS first ?
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 make a result table when troubleshooting, or testing/designing something pre-production.
Is there an equivalent in IBMi SQL and/or through Navigator SQL ?
Or do I have to spec it out through DDS first ?
Comment