Hey Mark,
Go here:
http://www-3.ibm.com/software/data/
then open the select a product window and choose your poison. From there you should see a Library option on the left frame..
Hope this helps!
DB2 Rules.
Hi All,
I'm curious to know if anyone has ever coded a SAS program with SMF110 records as input to get "program" level information as opposed to just "transaction" level information. By information I mean CPU time and response time information.
The only way I've ever seen...
All, the fix to this came through in another forum and it works!
C:\DB\stuff>db2 load from loadin.del of del modified by timestampformat=\"MM/DD/YYYY HH:MM\" insert into t1
without quotes around the datetime in the sorce file ...
ie
"",04/23/1997 10:30
rather than...
Thanks Marc,, that manual is slightly better than the one I was using, but nothing jumps out at me. There is a guy in another forum having the same problem, hmmmm.
So, being a mainframer, I'd go to IBMLINK to search for the problem or post a question, do you or anyone else know how to go about...
Thanks MarC...
Let me see if I understand you right....
the 1st run, I tried to use /'s in the control card on the TIMESATAMPFORMAT statement but it gave me this other error:
SQL3192N In the filetmod a user specified format "TIMESTAMPFORMAT" beginning
with the string...
Hello all,
I'm running 600k exported SyBase records into a DB2 table on NT using LOAD. The input data's timestamp isnt' in the format DB2 likes so I'm using the TIMESTAMPFORMAT "file type modifier" of LOAD.
I'm getting:
SQL3192N In the filetmod a user specified format...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.