Patti, Bruce, and Buddy,
The inclusion of the character settings and
CREATE SCHEMA syntax at the beginning of the output for the
UNLOAD has always existed. This method is
standard and has not changed. Patti, why the fake news? <gr>
Note:
You can also use the NOSCHEMA parameter of the
UNLOAD command to omit the character settings and
CREATE SCHEMA syntax from the beginning of the output.
OUTPUT TransferHumptyTable_t.rmd
UNLOAD ALL FOR HumptyTable_t NOSCHEMA
OUTPUT SCREEN
Once again, you are ONLY limited by your knowledge and experience of R:BASE!
HELP UNLOAD explains as well as illustrates it all!
Very Best R:egards,
Razzak
At 03:49 PM 2/23/2017, 'Patti Jakusz' via RBASE-L wrote:
I took out the connect Healthy.Rb1 command and
then got the following errors:
R>input healthy_table_newVR_Data_STructure.tbl
-ERROR- newVR is an undefined table. (2038)
-ERROR- Duplicate database name ( 720)
-ERROR- No database connected ( 325)
-ERROR- No database connected ( 325)
-ERROR- Unrecognized command - retype it ( 40)
-ERROR- Unrecognized command - retype it ( 40)
-ERROR- Unrecognized command - retype it ( 40)
-ERROR- Unrecognized command - retype it ( 40)
-ERROR- Unrecognized command - retype it ( 40)
-ERROR- Unrecognized command - retype it ( 40)
I think I have to put a connect in there
somewhere. Rbase used to have it in there automatically.
Patti
From: Buddy Walker <[email protected]>
To: [email protected]
Sent: Thursday, February 23, 2017 3:42 PM
Subject: RE: [RBASE-L] - Why can't we input a table anymore?
Patti
Take out the CONNECT Healthy
When the command CREATE SCHEMA….. R:Base
Creates the database and it stays connected.
Buddy
From: 'Patti Jakusz' via RBASE-L [mailto:[email protected]]
Sent: Thursday, February 23, 2017 2:37 PM
To: Karentellef via RBASE-L
<[email protected]>; RBASE-L Mailing List
<[email protected]>; [email protected]
Subject: [RBASE-L] - Why can't we input a table anymore?
Hello,
I like to do all my coding work in a copy of our
database. When I want to transfer any new
tables to the live database, I used to Export
the data & structure in the database copy and input it in the live database.
For the last year or so, 9.5 wasn't letting me
do that normally anymore. There was a
disconnect comment in the exported table but no
"connect Healthy.RB1" command. After a few
trials I figured out where to stick the connect command.
Now I have Rbase 10. I tried to stick the
connect command where I thought it should go,
just before the Create Schema command. But it
still doesn't work. Some of the errors I see:
R>input healthy_table_newVR_Data_STructure.tbl
-ERROR- newVR is an undefined table. (2038)
-ERROR- No database connected ( 325)
-ERROR- No database connected ( 325)
-ERROR- Unrecognized command - retype it ( 40)
-ERROR- Unrecognized command - retype it ( 40)
-ERROR- Unrecognized command - retype it ( 40)
-ERROR- Unrecognized command - retype it ( 40)
-ERROR- Unrecognized command - retype it ( 40)
-ERROR- Unrecognized command - retype it ( 40)
...
Here is part of my exported table commands:
...
DISCONNECT
SET STATICDB OFF
SET ROWLOCKS ON
SET FASTLOCK OFF
CONNECT Healthy.RB1
CREATE SCHEMA AUTHOR HEALTHY PUBLIC
CREATE TABLE `newVR` +
(`ssnum` TEXT (11), +
`momdob` DATE, +...
Can someone tell me what the problem is? And
why has this gotten so difficult? Sometimes
these files are huge and I don't think we should
have to go in through an editor and stick our
commands in the middle. Especially if it
doesn't work and I have to keep hitting the tab key for 10,000 records.
Thanks,
Patti
--
You received this message because you are
subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop
receiving emails from it, send an email to
<mailto:[email protected]>[email protected].
For more options, visit
<https://groups.google.com/d/optout>https://groups.google.com/d/optout.
--
You received this message because you are
subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop
receiving emails from it, send an email to
<mailto:[email protected]>[email protected].
For more options, visit
<https://groups.google.com/d/optout>https://groups.google.com/d/optout.
--
You received this message because you are
subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop
receiving emails from it, send an email to
<mailto:[email protected]>[email protected].
For more options, visit
<https://groups.google.com/d/optout>https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
