Stack Overflow
Stack Overflow

Questions tagged [oracle-rdb]

RDB is a database offering from Oracle for OpenVMS systems.

RDB is a database offering from Oracle for OpenVMS systems.

15 questions
3
votes
3 answers

How to improve the following SQL select date in RDB

I'm working on a .Net WinForms appliation that is connecting to a legacy RDB database... Some of the fields for dates are stored as integers (imagine 2010-01-04 was the integer 20100104) In the .Net world, I'd much rather work with datetime objects…
davidsleeps
  • 9,393
  • 11
  • 59
  • 73
2
votes
2 answers

Random record selection - VMS / RDB

I have been asked for a SQL statement to retrieve an arbitrary number of rows, randomly selected, from a data table in a database hosted on Oracle RDB on VMS. In MS SQL, it would simply be: SELECT TOP 5 * FROM MyTable ORDER BY NEWID() But I…
Wesley Long
  • 1,708
  • 10
  • 20
2
votes
3 answers

ODBC RDB 64-bit drivers

I need to get a 64-bit ODBC driver for a Windows 2008 r2 server to connect to an RDB database (v7.2). I downloaded the Oracle ODBC Driver for RDB 3.3.2.0 but I can't get it to connect. Has anyone used this? Should I be able to connect using…
user3265827
  • 21
  • 2
1
vote
1 answer

Java Connect to Oracle Rdb Driver and execute query

I have been asked to translate an automation code from VisualBasic into java 8. This is the old code: connectionString = "Provider=MSDASQL;" & _ "FileDSN=" & dsn & ";" & _ "DATABASE=Attach 'filename…
Emtec
  • 11
  • 1
1
vote
0 answers

Oracle rdb - not able to find rdbthin-7.4.3.1-jar. Can someone provide the link to download it

I am using rdbthin on openvms system. Currently I am using jar in my application with version 7.3.1.0. I am asked to upgrade it to version 7.4.3.1. I am not able find it anywhere including Maven Central repository and Oracle archive. Can someone…
amit ranjan
  • 31
  • 2
1
vote
1 answer

Shrink Oracle RDB database on OpenVMS

I have inherited a legacy OpenVMS system with an Oracle RDB database. Recently due to the backup size becoming stupidly large we have archived some of the older data out of the production database. Now we need to shrink the actual database files…
IKJ
  • 11
  • 2
1
vote
1 answer

Oracle Sql developer: Not showing source code of views, triggers, functions for Oracle RDB

I am using Oracle Sql developer to access my Oracle RDB database. I have installed Oracle RDB extension for Sql developer. I see there everything in object browser - tables, views, triggers, functions, procedures. The problem is When i want to see…
user3057239
  • 47
  • 1
  • 7
1
vote
2 answers

LSXLC ODBC Stored Procedure

I'm trying to connect to an Oracle RDB database using LSXLC (ODBC Connector). But when it comes to stored procedures I'm having a hard time getting it to work. The code below always results in "Error: Parameter name not supplied: fnl_date, Connector…
SamSon
  • 33
  • 1
  • 5
1
vote
1 answer

How to migrate from Oracle RDB for OpenVMS to MySQL in Windows?

I have a legacy Alpha server with a RDB database. This db is replicated in a MySQL db with many bad php scripts that drops all the tables and takes everything from the Alpha. This works very slow and is becoming unmaintainable. Is there a better way…
jcasalruiz
  • 117
  • 2
  • 8
1
vote
1 answer

SSIS Export to RDB doesn't work with NonUnicode Page File (8859-9)

I'm trying to export data from a table in MS SQL Server 2008 R2 to a RDB Database. But I'm having problems to export Hebrew strings to RDB because my SQL Server is Unicode and my RDB is Non-unicode. Here are the details: I'm using Oracle RDB Data…
Gabriel Marcos Jarczun
  • 219
  • 1
  • 10
0
votes
0 answers

How to access Oracle Rdb from Kubernetes

Part of our company's data is stored in Oracle Rdb database system running on OpenVMS. Processes running on our VMs connect to this database using ODBC driver. We're now moving most of our backend to .NET microservices deployed on Kubernetes cluster…
Gabriel
  • 377
  • 1
  • 3
  • 15
0
votes
0 answers

Execute dynamic query in stored prouder oracle Rdb

I want to execute one dynamic update query in oracle rdb through stored procedure. For example: Set :updateString='Update table set colum1, column2': I want to execute :updateString in procedure only. I have tried below cmds Exec…
Chirag Dhaduk
  • 13
  • 7
0
votes
0 answers

Error saving decimal value from SQL SERVER to RDB

i use openquery to save values from sql server to RDB through ORACLE RDB DRIVER ,ODBC insert into OPENQUERY([RDB_ODBC_ACCOUNTING], 'select * from test') (f1) values( 0.001) the value saved in rdb= 100 any suggest?
hussein
  • 5
  • 4
0
votes
1 answer

R RDB Query of date using RODBC Connection

I am trying to query an old Oracle RDB database using something like Sys.Date()-1 as that works in R, but I have not been able to find the right syntax. The following works but I want to run it on a regular schedule so a fixed time frame will not…
user7111645
  • 15
  • 3
0
votes
1 answer

Fun with Database Triggers and Recursion in RDB

I had a problem this week (which thankfully I've solved in a much better way); I needed to keep a couple of fields in a database constant. So, I knocked up a script to place a Trigger on the table, that would set the value back to a preset number…
Matt
  • 3,664
  • 3
  • 33
  • 39