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!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by devendrap
-
Aggregate Virtual column in master file.
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.- devendrap
- Post #3
- Forum: Information Builders, Inc.: WebFOCUS
-
Aggregate Virtual column in master file.
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- devendrap
- Thread
- Replies: 3
- Forum: Information Builders, Inc.: WebFOCUS
-
BTEQ and Derived table in mainframe...
After reducing length of line from downloaded file, it works... Thank you!!- devendrap
- Post #3
- Forum: NCR: Teradata
-
BTEQ and Derived table in mainframe...
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- devendrap
- Thread
- Replies: 2
- Forum: NCR: Teradata
-
-
Oracle Shell script
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...- devendrap
- Post #6
- Forum: Oracle: All versions
-
create SQL statement from flat file using shell script.
${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...- devendrap
- Post #6
- Forum: UNIX Scripting
-
Oracle Shell script
${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...- devendrap
- Thread
- Replies: 8
- Forum: Oracle: All versions
-
create SQL statement from flat file using shell script.
Your code is working like a magic Thanks a Ton!- devendrap
- Post #3
- Forum: UNIX Scripting
-
create SQL statement from flat file using shell script.
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...- devendrap
- Thread
- Replies: 6
- Forum: UNIX Scripting
-
-
Encrypt password.
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... -
-
Encrypt password.
Thanks for your quick response. Can I feed the values from file. -
encrypt database password
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...
