Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rrrkrishnan

    windows based Bteq batch script

    I see that unix shell variables can be referred to in bteq statements when the bteq code is embedded within the shell script. Is this possible in a batch script that will run in windows. If yes, can someone provide me with a sample script. Any info. on this is much appreciated. Thanks!
  2. rrrkrishnan

    import (mload/bteq) with duplicate keys)

    You would be able to load this data if you define the target table with a non unique primary index.
  3. rrrkrishnan

    How to suppress SQL in BTEQ export

    I was talking about the SQL stmt only and not the title. One of these set commands before the export cause the SQL to appear in the output. I have removed them now after seeing your post and the SQL doesn't appear, would you happen to know if it is the set format on that caused the problem...
  4. rrrkrishnan

    How to suppress SQL in BTEQ export

    How can I suppress the SQL stmt in the export file, when using BTEQ export. I am wanting a pipe delimited file as output. Can someone please help.
  5. rrrkrishnan

    aggregate functions in Oracle

    Are nulls ignored by aggregate functions like count(columnname), max, min... in all versions of Oracle older and newer. Thanks.
  6. rrrkrishnan

    145 Socket error - No response when attempting to connect to teradata

    Hi Happen to get this error message upon running an Ab intio graph. Would someone be able to explain why this would happen. Any help with this is much appreciated. Thanks!!! ABINITIO(DB15038): Teradata ODBC Error ABINITIO(DB15038): SQLCODE: 145 ABINITIO(DB15038): SQLSTATE: 08S01...
  7. rrrkrishnan

    Delete of very large table

    You can create a new table using 'create table tbl_nm' as select stmt; Apply the filter in the select. You can drop the original table and rename this new table.
  8. rrrkrishnan

    Access Module Error

    I think it has somthing to do with the path you have specified for the output file.
  9. rrrkrishnan

    Compare Question

    May be this is what you are looking for. select case when a.code is null then b.code else a.code as code, case when a.code is null then b.type else a.type as type, case when a.code is null then b.cond else a.cond as cond from tbl_a a full outer join tbl_b b on a.code=b.code
  10. rrrkrishnan

    Oracle 9iDS converting Minutes to Hour and Minutes

    Hi, I am trying to convert minutes to Hour and Minutes through PL/SQL, for exmple 6 minutes should be shown as 0 Hr and 6Mins. Any idea as how to do this? Thanks!
  11. rrrkrishnan

    A data modeling question

    Have a question regarding the design of a party account relationship table in a financial services model. Say there can be many parties associated with an account , and there is a role type column which defines the role a party plays on the account and there is a primary party indicator and...
  12. rrrkrishnan

    Locking Views For Access

    You will need an access lock only if there is a possibility that the concerned tables will be updated when queries are in progress. Multiple selects can run concurrently without access locks.
  13. rrrkrishnan

    SQL Query Help

    Something lke this should work. where_clause= (CASE WHEN &name IS NOT NULL THEN 'and name =' || &name else ' ' END) || (CASE WHEN &status IS NOT NULL THEN 'and status=' || &status else ' ' END) || (CASE WHEN &state IS NOT NULL THEN 'and state =' || &state else ' ' END) || (CASE WHEN &city IS...
  14. rrrkrishnan

    format an Decimal output with leading zeros URGENT

    There might be a better way to do this, but this works as well. select substr('00000',1,5-characters(trim(cast(cast(500.000 as integer) as char(5))))) ||trim(cast(cast(500.000 as integer) as char(5))) Substitute col_name for '500.000'
  15. rrrkrishnan

    Sql Join Help

    Try this. select case when isnull(a.name) then b.name else a.name end, case when isnull(a.time) then b.time else a.time end, purchased,sold,offered from (select * from tableA where time between '10:30' and '11:00') a Full outer join (select * from tableB where time between '10:30' and...
  16. rrrkrishnan

    How to drop a join index

    You get this error msg because the index is not created in the database 'PLATO'. To get the database in which the index is created, try this. select databasename, tablename from dbc.tables where tablename in...
  17. rrrkrishnan

    Retrieving Large View DDL

    If the same view name exists in multiple databases you can try this. select requesttext from dbc.tables where tablekind='V' and tablename='view_name' and databasename='database_name'.
  18. rrrkrishnan

    Retrieving Large View DDL

    Try this. select requesttext from dbc.tables where tablekind='V' and tablename='view_name'.
  19. rrrkrishnan

    Avoid all-rows scan in simple SQL statement (V2R4.1)

    Try this, but as Dieter says ,more info is needed to understand and improve the execution plan. SELECT WEEK_DIM.WEEK_DESC, FACT.SALES FROM FACT, (SELECT * FROM WEEK_DIM WHERE LAST_WEEK_IND = 1) WEEK_DIM WHERE FACT.WEEK = WEEK_DIM.WEEK
  20. rrrkrishnan

    Need SQL help on query

    Something like this should work. select * from sub_trans a where not exists (select * from all_trans b where b.join_col1=a.join_col1 and b.join_col2=a.join_col2 ......)

Part and Inventory Search

Back
Top