Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load data from BMC

Hello.

In advance I apologize if my question has an answer for molding - I have not found.

Problem in the following:

I use QvOdbcConnectorPackage to retrieve data from BMC Remedy, uses Oracle DB.

These are chosen from a fairly large table (more than 5 million records), so I want to limit the selection of ten values.

Create the following query:

[T1581]:

FIRST 10 LOAD "C200000006",

    "C200000015",

    "C230000009",

    "C260000001"

FROM "ARADMIN"."T1581";

ARADMIN- database name, T1581 - the name of the table.

But in return I get the error:

Cannot open file '<PATH_TO_DOCUMENT_DIRECTORY\>ADMIN.T1581' Cannot find the file specified.

Where did I go wrong? Thank you!

0 Replies