public void GetDataColumns(DB2Connection db2Connection) { db2Connection.Open(); DB2Loader loader = new DB2Loader(); loader.Connection = db2Connection; loader.TableName = "load_table"; DB2LoaderColumn myColumn; try { loader.CreateColumns(); for (int i = 0; i < loader.Columns.Count; i++) { myColumn = loader.Columns[i]; Console.WriteLine(myColumn.Name); Console.WriteLine(myColumn.DB2Type.ToString()); Console.WriteLine(myColumn.Size); Console.WriteLine(myColumn.Scale); Console.WriteLine(myColumn.Precision); Console.WriteLine(); } } finally { db2Connection.Close(); } }
public void GetDataColumns(DB2Connection db2Connection) { db2Connection.Open(); DB2Loader loader = new DB2Loader(); loader.Connection = db2Connection; loader.TableName = "load_table"; DB2LoaderColumn myColumn; try { loader.CreateColumns(); for (int i = 0; i < loader.Columns.Count; i++) { myColumn = loader.Columns[i]; Console.WriteLine(myColumn.Name); Console.WriteLine(myColumn.DB2Type.ToString()); Console.WriteLine(myColumn.Size); Console.WriteLine(myColumn.Scale); Console.WriteLine(myColumn.Precision); Console.WriteLine(); } } finally { db2Connection.Close(); } }