Stack Overflow
Stack Overflow

Questions tagged [rapidsql]

Rapid SQL is a SQL IDE allowing SQL scripting, query building, object management, debugging and version control.

Rapid SQL is a SQL IDE allowing SQL scripting, query building, object management, debugging and version control.

http://www.embarcadero.com/products/rapid-sql

27 questions
47
votes
6 answers

How to test an Oracle Stored Procedure with RefCursor return type?

I'm looking for a good explanation on how to test an Oracle stored procedure in SQL Developer or Embarcardero Rapid XE2. Thank you.
Ryan Fisch
  • 2,614
  • 5
  • 36
  • 57
4
votes
1 answer

Upgrade Rapid-Sql Client to work with Sybase 15

I'm attempting to run queries on a Sybase15 database via Rapid Sql. I'm getting error messages such as -- Number (103) Severity (15) State (207) Server (serverName) The identifier that starts with '[xxxxxxxxx_xxxxxx_xxxxxx' is too long. Maximum…
user270370
  • 151
  • 1
  • 3
  • 8
3
votes
2 answers

How to connect to Sybase Server/Database without port number using DSN or RapidSQL? Or how to find port number?

I have Some Sybase Server/Databases. I know 1. Server Name 2. Database Name 3. Username 4. Password. Using this I can connect using ISQL but while using RapidSQL it asks for port. I have existing application which uses DSN, while creating DSN also…
Pritesh
  • 1,938
  • 7
  • 32
  • 46
2
votes
1 answer

Export results with column headers in Rapid SQL

When I save the results of my query in Rapid SQL as a CSV or Excel file it doesn't include the column headers, where can I change the settings so it will include them?
Cameron Cox
  • 71
  • 2
  • 8
2
votes
0 answers

How do you transfer all your connection configuration from one RapidSQL install to another?

Has anyone encountered this problem? I have installed RapidSQL on a new team member's machine, and now I want to configure his installation with my connection configuration (20+ connections). Does anyone know how to do this? Is there a file RapidSQL…
Jose
  • 1,616
  • 4
  • 26
  • 38
2
votes
2 answers

How do you backup/export datasources in Embarcadero Rapid SQL?

How do you backup/export datasources for rapid SQL? (Could be typed rapidsql) It is a hassle for every developer to need to setup their own datasources or if you need to move to a different machine.
user606723
  • 4,918
  • 2
  • 27
  • 34
1
vote
1 answer

Rapid SQL/Sybase Open Client 15 Error: "Unable to find an available protocol driver structure"

All, After several months of not touching our databases I fired up Rapid SQL and get this error when I try and connect to a registered Sybase DB: "Layer (5) Origin (3), Severity (5), Number (3) ct_connect(): network_packet_layer: internal net…
ng5000
  • 12,330
  • 10
  • 51
  • 64
0
votes
2 answers

RapidSQL (Embacadero) error db2abind.dll is missing

I just installed rapidSQL 8.0.1 and tried connecting to a valid database. I'm fairly certain I have the right connection data (it was imported from another developer), but I'm getting the following error: db2abind.dll Cannot be loaded! That will…
Justin
  • 2,559
  • 3
  • 27
  • 33
0
votes
0 answers

Issue with parametrized queries using python

I am trying to use python to use a parametrized query through a list. This is the following code: loan_records =['604150062','604150063','604150064','604150065','604150066','604150067','604150069','604150070'] borr_query = "select distinct…
Richard
  • 1
  • 1
0
votes
1 answer

How to UPDATE a row everytime after a new entry is added to a table through INSERT INTO?

I have two tables: 'SingleTable' and 'SummaryTable' Then there is a function which summarizes some entries from SingleTable and writes it to SummaryTable. Everytime a SummaryTable entry is inserted, there is also Summary Key as an attribute (not a…
gpilka
  • 11
  • 4
0
votes
0 answers

I need to find a way to compare the nth row of data to (n-1)th row or nth row to (n+1)th row in Rapid SQL

I need to find a way to compare last row of data to the previous row or the 1st row data to the 2nd row so as to select specific data that have same values in the rows, in Rapid SQL. My table looks like…
Yogz
  • 1
  • 2
0
votes
1 answer

DB2 table's UNIQUE INDEX not showing in TABCONST and CONSTDEP tables

I am trying to query the unique indices from SYSCAT tables for some user tables using the query below which uses 4 catalog tables (INDEXES, INDEXCOLUSE, TABCONST, CONSTDEP). I realized all indices are there in INDEXES and INDEXCOLUSE tables but many…
CamelCamelius
  • 333
  • 2
  • 15
0
votes
2 answers

DB2 decfloat error

I receive the following error in my query: Invalid character found in a character string argument of the function "DECFLOAT". However I have made no changes to any of the fields I am selecting: select RQH.COMPANY, RQH.LAST_APRV_DT,…
Cameron Cox
  • 71
  • 2
  • 8
0
votes
1 answer

Is there a way to step through SQL code in debugging mode?

I am not a SQL developer, but I have a bit of SQL that is longer and more complex than my usual query/update. It is not a stored proc (policy thing). (The code reads some state into variables, selects some data into temp tables, and performs some…
Victor Grazi
  • 15,563
  • 14
  • 61
  • 94
0
votes
1 answer

Create Rows to Column in (RAPID) SQL without PIVOT

I am using the query below to pull up a list of accounts and the optional codes that go with them. There are 95 codes for each account, not just the 2 I am showing in the results below. SELECT DISTINCT Ref1.ACCOUNT_ID as Acct_Numb, Current_Date as…
Smarti
  • 1
  • 2
1
2