Search results for query: *

Hi, I am creating an 2007 Access DB (.accdb file) using Visual Studio and spire data export (www.e-iceblue.com/). However upon opening it in Access 2007 I get the message, "The Database has been upgraded to Access 2007 File Format. The new database cannot be shared with users of Access 2003...

Hi, I have Visual Studio Express 2010 SP1 installed on an Windows 2008 R2 Standard SP1. Upon trying to create an Access DB using the jet engine, I am getting the below error message. SDK is installed on this machine (got installed along with VS. Task could not find "AxImp.exe" using the...

MajP, Under Visio, "database", "import" there seems to be only 2 options: ie import an ERWin file (.ERX file) or import a Visio Modeller file (.IMD)

Thanks for your responses. I am merely trying to create a ER diagram and not a DB. I have a multiple tables and columns (200 odd columns in total) in an excel spreadsheet. Let me see if any of the freeware tools from the link that MajP suggested. I do have visio but I am not sure if I can copy...

Hi, I am trying to show DB Relationships using MS Access. I have the tables, fields and descriptions in an excel spreadsheet. I tried copying and pasting the all the fields of a table into the 'Design' screen in Access but it did not work. There are more than 200 columns so copying and pasting...

hi, I am using an AIX 5.3 machine and I would like to have a doskey like functionality. output of uname -a AIX XXXX 3 5 00C073004C00 Things used to work fine with escape + k, but I guess something was changed by the admins. Is there anything that I can add in my profile to get this...

sathyarama, thank you very much. I got the information needed from SYSCAT.TABAUTH Thanks philipose

Sathyaram, I was away for a few days. Here is the verion and fix pack information. hbuhydpf@usvh2euap2c:/home/hbuhydpf=> db2level DB21085I Instance "iuiap01" uses "64" bits and DB2 code release "SQL09014" with level identifier "01050107". Informational tokens are "DB2 v9.1.0.4", "s080122"...

Hi db2 gurus, I am not a DBA. If I have select / connect access to a DB2 database and a few tables in the database, can I view all the grants on that dataase and those tables ? If so can you direct me to which system table should I query on ? Thanks Philipose

Hi olded, I had also tried to cut the third field but did not work. hence i resorted to cutting the character. the solution you provided with awk works as advertised. thanks philipose

I got the below to work but still think that the perl soln was more elegant ls -ld $DIR} | cut -c15-24 | sed -e 's/ //g'

hi gurus, I can get the user id of a file / directory in perl using the below snippet. $uid = (stat("$pgm_name"))[4]; chomp($userid = qx!cat /etc/passwd | cut -f 1-4 -d ":" | grep -i ":$uid:" | cut -f 1 -d ":"!); printf "%s\n", $userid; I need to get the user id in a kshell script...

Khalid, Thanks for the tip. I made it work with arrays. Thanks Philipose # Set IFS to newline to overcome spaces in directory names OFS="$IFS" # Set IFS to newline IFS=' ' for LOGS in "$@"; do set -A LINES `grep -E "^.*$" ${LOGS}` LINE_NUM=0 ERROR=0 while [[ $LINE_NUM -lt...

Sraj, The attributes I can see when I do a lsuser or a lsuser -f are id, pgrp, groups, home, shell, gecos, roles, registry Maybe at an SA level they could change things. philipose

Khalid, I ran into one issue. The output of cat was the whole file in one line, ie each line is not read separately. I think your approach needs lines to be taken on at a time, right ? thanx philipose

Khalid, Thanks for your help. But this is what I get when I do lsuser -a account_locked $USER 3004-697 Attribute "account_locked" is not valid. A user with root access confirmed that he could see this attribute when running lsuser. I think I wont pursue this further. Thanks again philipose

hi, If I am a non root user and cannot read any files in /etc/security. Is it possible for me to see if a user id is locked or not ? The lsuser command does not show the account_locked attribute. The OS I am using is AIX 5.3 Regards philipose

Khalid, Cool. I think I got what you meant. I should be able to use this logic. Thanks again Philipose

Hi, I am a little stuck with a text extract issue. I have a files that would have a pattern as below some text ........... <error> some message .............. </error> some text ........... <error> some message .............. </error> some text ........... I am interested in extracting...

Bummer. I dont have sudo rights and prefer to keep this within shell scripts. I am hoping a better soln will prevail.