Error while selecting column form a hash file

[nkln@you]

I populated a hash file Hash_Booking with filed name A. There is only one value for column A and that value is 0.


When i went to adminstartor command and executed

select A from Hash_Booking .

It says DataStage/SQL: syntax error . Unexpected symbol . Token was "A". Scanned command was from Hash_Booking SELECT A.

But when i execute

select * from Hash_Booking ;It is showing

COUNT.......

0.0000

1 RECORDS LISTED.

I verified once again that column A is present in hash file.

But why do i get this error

[ArndW]

Try renaming your column from "A" to another name, preferably one that is not a reserved DataStage keyword and see if you have the same problem.

[Sunshine2323]

Try

select A from Hash_Booking;

Lets us know the result

[ray.wurlod]

A is a reserved word. You need to quote the column name in double quotes if it is a reserved word or contains spaces. This is known as a "delimited identifier".

Code: Select all

SELECT "A" FROM Hash_Booking;

Of course, if you want to select the literal 'A' from every column, SQL rules mandate single quotes.

Code: Select all

SELECT 'A' FROM Hash_Booking;

[nkln@you]

Ray, Thanks ,

I changed the column name and also hash file name. This worked now.