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
Can i used DMLsentences in DS engine shell ?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Teradata DML statements must be executed in a Teradata environment such as BTEQ. You can, of course, invoke that environment from the DataStage environment.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: