Recent content by devendrap

Thanks for your reply... I am coming from BusinessObjects world. I was thinking to make most of the joins and calculations at metadata (or master file or synonym) so It can be reused for reports.

I am new to Webfocus. Can I add aggregate column in the Master file? Eg. Sum(tablename.columname) I would like to use the same column in multiple reports. Thanks

After reducing length of line from downloaded file, it works... Thank you!!

I have SQL for updating table. The SQL has derived table. The SQL works in Queryman but doesn't work in mainframe BTEQ. Appreciate your help. Thanks

You are right. Thanks you.

I used following script, it is workig fine, I don't believe this is good way to do it. Please provide your suggestions: while read plant TS_date junk do [ "$plant" = "Plant" ] && continue ${ORACLE_HOME}/bin/sqlplus -s $USER_DW_ADMIN/$PWD_DW_ADMIN << EOF set colsep '' set pagesize 0 set...

${ORACLE_HOME}/bin/sqlplus -s $USER_DW_ADMIN/$PWD_DW_ADMIN << EOF set colsep '' set pagesize 0 set heading off set feedback off set echo off set arraysize 5000 set termout off SET WRAP OFF spool $DW_LST/temp11 while read plant TS_date junk do [ "$plant" = "Plant" ] && continue...

${ORACLE_HOME}/bin/sqlplus -s $USER_DW_ADMIN/$PWD_DW_ADMIN << EOF set colsep '' set pagesize 0 set heading off set feedback off set echo off set arraysize 5000 set termout off SET WRAP OFF spool $DW_LST/temp11 while read plant TS_date junk do [ "$plant" = "Plant" ] && continue...

Your code is working like a magic Thanks a Ton!

Hi, I would like to create SQL statements from flat file. Flat file has follwing values: Plant Date AB1 2005-10-10 AC1 2004-10-10 Shell script has following variables: set type01 = "xxx" SQL should be: Insert into qa set date01 = 2005-10-10(from flat file), plant01=AB1(from flat...

Thanks

Basically I am trying to put security on the database password, which is located in the CGI/PERL scripts. The encrypted CGI/PERL file needs read access to use for decryption script. If user knows the file name, user can put in the URL and open the file and get encryption password as well as...

The file will have only encrypted password.

Thanks for your quick response. Can I feed the values from file.

How to encrypt database password in the perl script? Currently I have database password stored in the perl script, and CGI scripts uses this perl script to connect to database. I would like to encrypt the database password in separate file. I have shell script to encrypt password file. I have...