im 20yrs old and im considering studying IT. im not realy sure what exactly it is that i wanna do in this field. all i know is d@ i want a very creative and good paying job that involves computers.i was advised by a friend to do developing, programming or web writing (im not even [...]
How can I change the collation name of a specific database?
Hi Respected IT People , I am AS400 professional and working with good company. as we hv seen lot many up & downs in the Market in AS400. I am scared abt my future.I dnt know what to do ? And fact in the market is Many companies are migrating to Mainframe & Many companies [...]
Im quite new to database security and MSSQL server 2005 and 2008 and was hoping to find some extra sites or books to help as I am currently writing an application to send OS info and service tags to our SQL server. I obviously can t have the SQL server directly on the internet with [...]
Hello. I am about to start pursuing education to eventually become an MCSE. I am extremely good with computers naturally, but have absolutely no experience with anything like this. In other words, I don’t even know where to start. I have no computer education yet and to be honest, I don’t even really understand the [...]
There is a task type column and a cost column. I need to pull out only the costs related to the task type steel. I was thinking an IIf ( [tast type] = steel, sum, 0 ) statement would work. Not making it happen. Any ideas? I actually want to pull out all of the [...]
hi, I am an engineer (electronics and telecomm) by qualification. i am presently working in a govt organisation since 6years. though technical i am looking for a change to a private organisation. which course i should opt for and what are the options available. i a resident of Indian and residing in india.
Hi Guys, The problem I’m having is to tie in a progress-bar to a dataBase file so that whenThe user advances through the files(or backs up), the progressBar shows the relative position of the column they’re at to the dynamically sizable total # of columns in the dataBase. This should be a relatively simple coding [...]
hello.. i have worked on cisco routers (2500, 4500) from around 95-2000 and have been doing some other work since then.. in trying back to networking i got my ccna a month ago and i thought i’d have an easier time getting a job since i do have cisco experience although not recent.. but it [...]
I have an application which does monthly update of data in Database and also does select queries or minor updates. Monthly updates last for 24 hrs and application is down during the time. I am planning to use 2 schemas. The first one will be used for minor updates/selects. The other one will be used [...]
Whats a good tool/software to import (excel, csv) into IBM DB2? Would be great if this tool/software is free or doesn’t costs to much. thanks
I am a new graduate with 1 year of experince in a well known Aircraft Manufacturing company. My title is “Database Administrator – Operations” and I deal mainly with SQL Server back ends with Visual Basic or HTML front ends. I currently deal with many internal customers and relay the feedback to the rest of [...]
How does one auto send e-mail from access
what is simple deffination and example of collation
Hi , We have ORACLE RDBMS 9.2.0.6 ,and E-business suit 11.5.10.2 . Platform is Solaris 10. The applicatioin and the database are on the same server. We have users accessing this application from another Geographical location .Those users are facing performance problems due to the link . Question: Can we add another server and install [...]
I’ve been working in banking doing some IT work. I Graduated with a degree in CIS (May 07). How do I transition into the IT feild? should I work temp jobs to get the training? Please Help.
Hi, i´m genetarting a csv file from an open hub in BW so i need to convert it into a xlsx one due to i need to upload it into the microsoft share point. is there an abap function that does it? i know that there is one to convert an xls one into a [...]
How to explicitely Lock a record of a file in a SQLRPGLE program using embeded SQLs?
I wish to: 1.) define a timestamp and initialize it to system date/time. What odes the D spec look like for this or can it not be done in the D spec? 2.)Load a data structure whihc is formatted to match timestamp defaults with data by field (CCYY MM DD…etc,). I want to then 3.) [...]
I want to run DBCC command on linked server remotly





