1
  • How to sort a db2 table column, containing date stored in char format.

    i have a column which is not Y2K complaint, the values are stored in char format like ddmmyy ( i know its totally dumb), i need to sort based on ascending or descending order.  051193 -> 5 nov 1993  140308 -> 14 march 2008  141211 -> 14 december 2011   Now how do i sort this column...

    Maverickgiant40 pointsBadges:
  • DB2 table load JCL with current timestamp

    Hi I need load the data from the flat file to db2 table by dsnuproc (mainframe ) utility my file dont have the timestamp value but the cloum in the table col2 declared as timestamp not nulll caould you please help how do load current timestamp.Thanks in advance Regards Manju

    Manju25 pointsBadges:
  • Extracting data from a DB2 table using IKJEFT01

    I'm trying to extract data from a DB2 table via an SQL query and use IKJEFT01 to create a flat file. However, one of the non-key fields contains characters that are not nulls but non-printable. Whenever IKJEFT01 extracts these characters it changes them to nulls in the flat file. Is there an...

    AlanJ5 pointsBadges:
  • Mainframe batch DB2 table I-O monitoring

    Dear Sir or Madam: I can examine the excp counts for flat, VSAM, IMS files in the JCL batch JES JOB Log statistics, both while executing & when job has completed. How do you monitor that I/O for DB2 tables? Thank you, Michael Piccolo

    Pic40 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following