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

23 questions
42
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,295
  • 4
  • 33
  • 53
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
  • 141
  • 1
  • 2
  • 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,810
  • 7
  • 29
  • 43
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
  • 1
  • 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,488
  • 4
  • 24
  • 35
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,425
  • 2
  • 25
  • 33
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
  • 11,400
  • 10
  • 49
  • 63
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,479
  • 3
  • 26
  • 33
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
  • 134
  • 11
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
  • 1
  • 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
  • 13,263
  • 13
  • 53
  • 85
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
0
votes
0 answers

SQL for Oracle 11g

I have a query that was given to me that I modified for my use. I'm having issue with the double of total billed amounts. However some accounts the aggregation is correct while in other accounts its double. my sql is this. SELECT…
les campbell
  • 1
0
votes
0 answers

How to change DataGrip settings so that it detects double quotes as strings instead of columns?

I just started using Jetbrains DataGrip at work for Sybase DB developement. All the developement is done using ASE ISQL or RapidSQL. they both accept select "test" as valid command and print test but if i run the same command in DataGrip it detects…
Gurbakhshish Singh
  • 964
  • 1
  • 8
  • 23
0
votes
3 answers

Creating tables through a script & how to run the script

Ive got a couple of scripts that I need to run on my databse. So I have a few questions. Im simply using Connection, CommandText,CommandType and CommandTimeout when opening a connection to the databse. First question - Does anyone know if through…
Vibralux
  • 83
  • 2
  • 2
  • 7
1
2