Scale Property (DbLoaderColumn)
Gets or sets the number of decimal places to which column value is resolved.
public int Scale {get; set;}
'Declaration
Public Property Scale As Integer
Property Value
The number of decimal places to which column value is resolved. The default value is 0.
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();
}
}