Styjun

1, 2, 4, 8, 16, ... 33?

Should the average user with no special access rights be worried about SMS-based 2FA being theoretically interceptable?

My Project Manager does not accept carry-over in Scrum, Is that normal?

How to create fractional SI units (SI...sqrts)?

What are the consequences of high orphan block rate?

How to justify a team increase when the team is doing good?

Reorder a matrix, twice

Why weren't the Death Star plans transmitted electronically?

Do we have any particular tonal center in mind when we are NOT listening music?

Pi Zero Work With Embedded WIFI And Cellular USB Modem

Clear text passwords in Unix

Is there a recurrence relation which has no closed formula?

Is it a good idea to leave minor world details to the reader's imagination?

A famous scholar sent me an unpublished draft of hers. Then she died. I think her work should be published. What should I do?

Golf (6-card) Golf!

Why does (inf + 0j)*1 evaluate to inf + nanj?

Hangman Game (YAHG)

Excel Solver linear programming - Is it possible to use average of values as a constraint without #DIV/0! errors or sacrificing linearity?

Why are there two fundamental laws of logic?

How can this Stack Exchange site have an animated favicon?

Labview vs Matlab??Which one better for image processing?

Does the Way of Shadow monk's Shadow Step feature count as a magical ability?

Is differentiation as a map discontinuous?

practicality of 30 year fix mortgage at 55 years of age

How to load a CSV file into Altibse

How does database indexing work?How can I prevent SQL injection in PHP?How to list the tables in a SQLite database file that was opened with ATTACH?How to return only the Date from a SQL Server DateTime datatypeHow to concatenate text from multiple rows into a single text string in SQL server?Save PL/pgSQL output from PostgreSQL to a CSV fileHow do I UPDATE from a SELECT in SQL Server?How to query MongoDB with “like”?How do I import an SQL file using the command line in MySQL?SQL Server Insert Statement From a CSV File

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I have an extremely simple altibase database with only 1 table, the problem is i can't figure out how to load the data into the database.

As far as i am aware altibase uses the iLoader tool, so the following code should work but instead throws a syntax error. It does not specify where the error is.

CREATE TABLE SentimentData (
 FinalScore DECIMAL(10,4),
 maxPosScore DECIMAL(9,3),
 maxNegScore DECIMAL(9,3),
 commentID char(10)
);

iloader in [-T SentimentData] [-d /home/cory/SentimentData/2005/RC_2005-12.sentiment] [-rule csv];

The create table statement works perfectly i have just included it to show how the table is formatted if this is important.

To my knowledge, the iLoader line should import the data into the Table SentimentData, from the specified CSV file.

I have also tried the bulkinsert command and this gives the same error, a syntax error without specifying where the error actually is.

BULK INSERT SentimentData
 FROM '/home/cory/SentimentData/2005/RC_2005-12.sentiment'
 WITH
 (
 FIELDTERMINATOR = ' ', --field delimiter (tab)
 ROWTERMINATOR = 'n', --next row is a new CSV line
);

Is there a different command I am missing in Altibase I am missing or have I just misread the manual somewhere?

sql isql

share|improve this question

asked Mar 28 at 17:36

me910me910

111 silver badge11 bronze badge

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  So i can't delete the question but i have figured out the answer so i'll note it here just incase anyone else runs into the same issues i had. iLoader does not run through altibase as i was led to believe (something you'd think would be mentioned in the manuals) but must be run separately by loading the Altibase/bin/iloader file (default location). Here the iLoader commands are run and then the data can be worked with through altibase itself.
  
  – me910
  Apr 3 at 15:45
  
  

  
  
  
  

add a comment
 | 

0

I have an extremely simple altibase database with only 1 table, the problem is i can't figure out how to load the data into the database.

As far as i am aware altibase uses the iLoader tool, so the following code should work but instead throws a syntax error. It does not specify where the error is.

CREATE TABLE SentimentData (
 FinalScore DECIMAL(10,4),
 maxPosScore DECIMAL(9,3),
 maxNegScore DECIMAL(9,3),
 commentID char(10)
);

iloader in [-T SentimentData] [-d /home/cory/SentimentData/2005/RC_2005-12.sentiment] [-rule csv];

The create table statement works perfectly i have just included it to show how the table is formatted if this is important.

To my knowledge, the iLoader line should import the data into the Table SentimentData, from the specified CSV file.

I have also tried the bulkinsert command and this gives the same error, a syntax error without specifying where the error actually is.

BULK INSERT SentimentData
 FROM '/home/cory/SentimentData/2005/RC_2005-12.sentiment'
 WITH
 (
 FIELDTERMINATOR = ' ', --field delimiter (tab)
 ROWTERMINATOR = 'n', --next row is a new CSV line
);

Is there a different command I am missing in Altibase I am missing or have I just misread the manual somewhere?

sql isql

share|improve this question

asked Mar 28 at 17:36

me910me910

111 silver badge11 bronze badge

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  So i can't delete the question but i have figured out the answer so i'll note it here just incase anyone else runs into the same issues i had. iLoader does not run through altibase as i was led to believe (something you'd think would be mentioned in the manuals) but must be run separately by loading the Altibase/bin/iloader file (default location). Here the iLoader commands are run and then the data can be worked with through altibase itself.
  
  – me910
  Apr 3 at 15:45
  
  

  
  
  
  

add a comment
 | 

I have an extremely simple altibase database with only 1 table, the problem is i can't figure out how to load the data into the database.

As far as i am aware altibase uses the iLoader tool, so the following code should work but instead throws a syntax error. It does not specify where the error is.

CREATE TABLE SentimentData (
 FinalScore DECIMAL(10,4),
 maxPosScore DECIMAL(9,3),
 maxNegScore DECIMAL(9,3),
 commentID char(10)
);

iloader in [-T SentimentData] [-d /home/cory/SentimentData/2005/RC_2005-12.sentiment] [-rule csv];

The create table statement works perfectly i have just included it to show how the table is formatted if this is important.

To my knowledge, the iLoader line should import the data into the Table SentimentData, from the specified CSV file.

I have also tried the bulkinsert command and this gives the same error, a syntax error without specifying where the error actually is.

BULK INSERT SentimentData
 FROM '/home/cory/SentimentData/2005/RC_2005-12.sentiment'
 WITH
 (
 FIELDTERMINATOR = ' ', --field delimiter (tab)
 ROWTERMINATOR = 'n', --next row is a new CSV line
);

Is there a different command I am missing in Altibase I am missing or have I just misread the manual somewhere?

sql isql

share|improve this question

asked Mar 28 at 17:36

me910me910

111 silver badge11 bronze badge

CREATE TABLE SentimentData (
 FinalScore DECIMAL(10,4),
 maxPosScore DECIMAL(9,3),
 maxNegScore DECIMAL(9,3),
 commentID char(10)
);

iloader in [-T SentimentData] [-d /home/cory/SentimentData/2005/RC_2005-12.sentiment] [-rule csv];

BULK INSERT SentimentData
 FROM '/home/cory/SentimentData/2005/RC_2005-12.sentiment'
 WITH
 (
 FIELDTERMINATOR = ' ', --field delimiter (tab)
 ROWTERMINATOR = 'n', --next row is a new CSV line
);

share|improve this question

asked Mar 28 at 17:36

me910me910

111 silver badge11 bronze badge

share|improve this question

asked Mar 28 at 17:36

me910me910

111 silver badge11 bronze badge

asked Mar 28 at 17:36

me910me910

111 silver badge11 bronze badge

asked Mar 28 at 17:36

me910me910

111 silver badge11 bronze badge