Recent content by Jeevan23

  1. J

    Materialized Views In Progress

    Thanks for reply.
  2. J

    Materialized Views In Progress

    Hi, Is it possible to create materialized views in progress openedge. if it is possible, how can we create it. please suggest me. thanks.
  3. J

    Too Many Values Specified (7531) Error

    Hi, we are getting this error while we running below query in progress11 through odbc tester tool. Error :-[DataDirect][Odbc Progress openedge wire protocal driver][openedge]Too many Values Specified (7531) Query : select SUBSTRING(g."Account#",(((select sum(ss.Seg_Len) from hrdb.ab_cd_Def ss...
  4. J

    Mutiple Database Connect Using Proenv Command Prompt In Progress 9.1e

    Hi, as per progress documentation, Connect statement will work for connecting the other database from sql explorer as below. CONNECT TO "progress:T:localhost:custdb" AS "cust_conn"; but when am running this statement, it is giving the syntax error (7587). how can we write connect statement ...
  5. J

    Mutiple Database Connect Using Proenv Command Prompt In Progress 9.1e

    Hi, We can connect sql explorer through proenv cmd prompt in progress, for single database by using below syntax sqlexp –char –S port –H hostname –db database –user username –password pwd. but, how can we connect mutiple databases in sqlexplorer of Progress 9.1e. ? Actually i need to write...
  6. J

    Reg Expressions In Progress

    Hi, Is Progress 9.1e support regular expressions. Actually i need to divide the Account Number in different parts based on regular expression pattern, how can i do this in progress 9.1e? if progress supoorts reg expressions, please give me the guidance to use reg expression in sql query. Thanx.
Top