Can i used DMLsentences in DS engine shell ?

[alexcol]

good afternoon.

Now that i could connect to a Teradadata database using the information provided in the 3 mains files, i tried to run some selet staments but failed. for instance:

select P.pARTY_sTART_dT, count(*)
SQL+from DWH_DATA.INDIVIDUAL_NAME_HIST INH
SQL+inner join DWH_DATA.PARTY P
SQL+on INH.iNDIVIDUAL_pARTY_iD = P.PARTY_ID
SQL+and P.pARTY_sOURCE_CODE = 1 /* scl-usuario */
SQL+and P.pARTY_sTART_dT > '2010/11/30'
SQL+group by 1
SQL+ORDER BY 1
SQL+

DataStage/SQL: Table "DWH_DATA.INDIVIDUAL_NAME_HIST" does not exist

Running a simple select statement select * from table yiels the error that the table doesnt exist, even i f i run the whole shema file DATABASE.table

Id appreciate your help

[ray.wurlod]

Short answer: No.

Teradata DML statements must be executed in a Teradata environment such as BTEQ. You can, of course, invoke that environment from the DataStage environment.

[alexcol]

OK, thanks for your reply but with the sentence below why it yields the error message "the table doesnt exist?" , whats wrong with this sentence, or how can i move to the database where the table hosts and run the required select statement?

[chulett]

The table doesn't exist in the project you are connected to. And you can't move anywhere in there where it will find anything other than DataStage objects.

[ray.wurlod]

The DS shell is attempting to find a DataStage (UniVerse) table of that name. It doesn't exist.