Life, the Internet, and Everything!

It’s dreaded timestamp in SQL server. Though the name says …

Comment on Tips for Using Time Stamps in ILE RPG by Admin.

It’s dreaded timestamp in SQL server. Though the name says it is timestamp, it’s really not. So don’t do a read/write on that column. It’s a kind of rowid precisely. By definition from SQL server books:

The SQL Server timestamp data type has nothing to do with times or dates. SQL Server timestamps are binary numbers that indicate the relative sequence in which data modifications took place in a database. The timestamp data type was originally implemented to support the SQL Server recovery algorithms.

It further states Never use timestamp columns in keys, especially primary keys, because the timestamp value changes every time the row is modified.

Hope it helps.

Admin Also Commented

Tips for Using Time Stamps in ILE RPG
Nothing wrong with the trigger you made. What is causing your problem is the insert statement.

Several things needs to be considered in an insert statment.
1. You need to make sure all NOT NULL columns is included in your insert statement

2. If your not specifying the columns in the insert statement, make sure that the values clause contain ALL the columns in the table and in the correct order.

3. You can also specify the columns which the insert statement will populate. In your example, insert into emp(col1, col2, col3, col4) values (10, ‘Adam’, 50000, ‘MIS’); Only col1, col2, col3, coll4 will have values and the other columns will have a value of null.


Tips for Using Time Stamps in ILE RPG
” A data type in a programming language is a set of data with values having predefined characteristics. Examples of data types are: integer, floating point unit number, character, string, and pointer. Usually, a limited number of such data types come built into a language. The language usually specifies the range of values for a given data type, how the values are processed by the computer, and how they are stored. ”

Buddy you’re losing a lot of points by asking all these questions and I’m just going on google.


Tips for Using Time Stamps in ILE RPG
Hi –

It all depends on how you send the date to Oracle from VB.

If you want to use the sysdate, and you always want to use the sysdate as the timestamp when inserting a record, then it is best to make the column in your Oracle table have a DEFAULT value of sysdate and not pass the date to Oracle when inserting the record. By default, if no value is passed to the date field, then on insert it’ll grab the sysdate by default and you don’t have to worry about it.

As an example, say you have table TEST with 3 columns:

SQL> create table test (x number, y timestamp default sysdate, z varchar2(12));
Table created.

SQL> insert into test (x,z) values (1,’hello’);
1 row created.

SQL> commit;
Commit complete.

SQL> select * from test;

X Y Z
———- ——————————————— ————
1 12-MAR-08 09.09.18.000000 PM hello

Or you can explicitly enter sysdate as a value:

SQL> insert into test (x,y,z) values (1,sysdate,’hello again’);

1 row created.

SQL> commit;

Commit complete.

SQL> select * from test;

X Y Z
———- ———————————————— ————
1 12-MAR-08 09.09.18.000000 PM hello
1 12-MAR-08 09.12.13.000000 PM hello again


Recent Comments by Admin

5 Tips for Writing the Perfect Blog Post
If you use WordPress, or Blogger, or any other modern blogging tool for that matter, the search engines are “pinged” and know right away that you have made a post. So, don’t worry about submitting it to search engines manually (and for heaven’s sake, don’t pay someone who claims to do that)!

In general, the best method nowadays is to generate some social traffic. Post a link to you post to Facebook, Twitter, pin your post’s featured image to Pinterest.


Catchy Headlines
Business Models are simulations of actual business functioning.
They act as ideal real life examples,and help participants actively discuss the pros and cons of the situation given.

A business Model gives a Full Account of any particular Business Scenario. Readers of this model/ Participants are then asked to discuss the strengths and weaknessess of it. Put it simply, one has to SWOT analyze the Business Model based on different parameters.

Each participant comes up with his/her own views on the subject. Cumulative views and different view points are then listed and ranked based on their importance and relevance.

Thus at the end of the session, a business models suitability and viability is drafted and conclusions are drawn thereon.

The more the Business Model Analysis a person does, the more exposed he gets to real life corporate situations.
Hence it is said, that Business Models act as Good Simulators.


Search Engine Optimization
A search engine is a service provided by some company (Google, Yahoo, Microsoft, etc.) which will search through millions of web pages for keywords that a person types into a field. For instance, if I type “Puppy” into a search box on Google’s web site, there are currently 40,800,000 matches available. If the search provider has a good search algorithm in their software, then the most relevant pages should be listed first. In my case, I’m a happy searcher, because after the Google Image samples, the first result listed is the Puppy Linux website, which is the only Puppy I would ever be searching for online. Most search providers keep track of what websites people will actually visit after doing a search. They then use the results to make sure those pages are closer to the top of the list for the next time someone searches for the same keyword(s).

Image search optimization is about using images on your website to draw more “click-throughs” from the search provider, thereby raising your rank in the search list. This, in turn, helps to ensure that you keep getting more visits to your site. A neat article I just found by typing “image search optimization” into Google Search is linked below.


New York Skyline
Below is a link with pictures of the NYC skyline.

A view of city of great magnitude rises out of the open like a curtain for a show that always staging the world’s greatest act, you immerse yourself as one of the players of the greatest city in the world.


Business Niche – Adding Content for SEO
Http://fefoo.com/
Fefoo is not a search engine, its an application that helps you search better. It uses the traditional search engines to search. You search on categories and your search is more refined from the time you start searching. In case you don’t use categories it works like a normal search engine.

http://www.springo.com/
Springo is a Web shortcutting tool that empowers users to rapidly and easily navigate to the best websites for any purpose.

Welcome to Viewzi


Each view contains a set of results that are displayed visually – and each view has a different perspective.

http://www.yoozila.com/
Yoozila is a powerful new search engine. It’s primary purpose is to provide you with relevant results and present them in a fresh web 2.0 beautiful manner.

http://www.findthebest.com/
FindTheBest is an objective comparison engine that allows you to find a topic, compare your options and select the best choice for you.


 
Next Post
092217_0320_WhatWillThe1.jpg
Miscellany

What Will The Next Generation Of Aspiring Entrepreneurs Look Like?