I simply could not resist ....
Did you know that 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?
Here's how ...
OUTPUT TransferHumptyTable_t.rmd
UNLOAD ALL FOR HumptyTable_t NOSCHEMA
OUTPUT SCREEN
Remember, you are ONLY limited by your knowledge and experience of R:BASE!
Very Best R:egards,
Razzak.
At 03:21 PM 2/23/2017, 'Patti Jakusz' via RBASE-L wrote:
Hi Bruce, Are you saying I should get rid of the lines below?
Patti
SET SINGLE=NULL
SET SINGLE='_'
SET MANY=NULL
SET MANY='%'
SET IDQUOTES=NULL
SET IDQUOTES='`'
SET CURRENCY '$' PREF 2 B
edit this out?--> DISCONNECT
edit this out?--> SET STATICDB OFF
edit this out?--> SET ROWLOCKS ON
edit this out?--> SET FASTLOCK OFF
edit this out?--> CREATE SCHEMA AUTHOR HEALTHY PUBLIC
CREATE TABLE `newVR` +
(`ssnum` TEXT (11), +
`momdob` DATE, +
From: Bruce Chitiea <[email protected]>
To: [email protected]
Sent: Thursday, February 23, 2017 3:13 PM
Subject: Re: [RBASE-L] - Why can't we input a table anymore?
Patti:
From within your development database, have you tried:
OUTPUT TransferHumptyTable_t.rmd
UNLOAD ALL FOR HumptyTable_t
OUTPUT Screen
... editing out the few lines of schema creation commands,
disconnecting from the development database, connecting to the
production database, then performing:
RUN TransferHumptyTable_t.rmd
BROWSE * FROM HumptyTable_t
... from the R> Prompt?
Since this is a new table, your only concern would be duplicate
column names/definitions.
Bruce Chitiea
SafeSectors, Inc.
909.238.9012 Mobile
------ Original Message ------
Sent: 2/23/2017 11:36:46 AM
Subject: [RBASE-L] - Why can't we input a table anymore?
From: "'Patti Jakusz' via RBASE-L"
<<mailto:[email protected]>[email protected]>
To: "Karentellef via RBASE-L"
<<mailto:[email protected]>[email protected]>;
"RBASE-L Mailing List"
<<mailto:[email protected]>[email protected]>;
"[email protected]"
<<mailto:[email protected]>[email protected]>
Cc:
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.
