JR60783: PROVIDE ADDITIONAL FILE FORMAT OPTIONS FOR LOAD FROM FILE IN SNOWFLAKE CONNECTOR

IBM InfoSphere Information Server, Version 11.7.1.1 (Fix Pack 1)
IBM InfoSphere Information Server, Version 11.7.1.1 for AIX
IBM InfoSphere Information Server, Version 11.7.1.1 for Windows
IBM InfoSphere Information Server, Version 11.7.1.1 for Linux

APAR status

• Closed as program error.

Error description

• Currently when Writemode=Load from file, the staging area is
  created with the default format type options available for
  creating the staging area and data is loaded into it. This
  might cause an issue if the input data is not in the format
  which matches these default values.
  

Local fix

• No Local Workaround
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Snowflake connector users
  ****************************************************************
  PROBLEM DESCRIPTION:
  Provide certain file format options to create the staging area
  for Load from file option in Snowflake Connector
  ****************************************************************
  RECOMMENDATION:
  Apply patch JR60783 on engine tier
  ****************************************************************
  

Problem conclusion

• The user is given the flexibility to create a staging area which
   will suite the data that is being loaded into the table.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INFO SRVR PLATF

• Fixed component ID

  5724Q3612

Applicable component levels

• RB70 PSY

     UP

• RB71 PSY

     UP