I need help to create a sequential file with metadata
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 6
- Joined: Tue May 23, 2006 10:25 pm
- Location: Bangalore
I need help to create a sequential file with metadata
I need help in knowing how to create a sequential file that will contain the metadata definition of all the columns , like column name , data type , length [/b]
-
- Participant
- Posts: 6
- Joined: Tue May 23, 2006 10:25 pm
- Location: Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There is nothing directly within DataStage for doing this. You can generate this information using the Reporting Assistant or "hacking" the repository (perhaps with a DataStage job). You would need to know what fields within DS_METADATA contain the information you require; this metadata is not in the public domain.
Years ago I posted here a job (job control routine) for dumping a table definition in one of a number of formats; perhaps you could search for it and adapt that code.
Years ago I posted here a job (job control routine) for dumping a table definition in one of a number of formats; perhaps you could search for it and adapt that code.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: I need help to create a sequential file with metadata
Go out to IBM and download the Universe documentation. This will help you learn to write a program in Universe Basic that will parse the data from the underlying Universe files. I'm an old Pick programmer so it was not too difficult for me.
Some Hash Def to get you started ...
Some Hash Def to get you started ...
DSArgumentMap
ProjectName
JobName
ContainerName
OutputFromStage
LinkName
RtnArgument
ArgumentMap
DSColumns
ProjectName
JobName
ContainerName
OutputFromStage
LinkOrTblDefnName
ColumnName
DataElementName
ColIsKey
ColSqlType
ColLength
ColScale
ColNullable
ColDisplaySize
Association
FieldPos
FieldType
IsGroupOn
AggSortPos
AggSortOrder
ColNLSMapName
ColNull
AllowCRLF
PadChar
PadNulls
DateMask
DependField
LevelNo
NativeType
Occurs
RedefinedField
SignIndicator
SignOption
SyncIndicator
Usage
DSDataElements
ProjectName
DataElementName
DECategory
DEShortDesc
DEBaseType
DESqlType
DEPrecision
DEScale
DENullable
DEDisplaySize
DEDateModified
DELastUpdated
DSJobParameters
ProjectName
JobName
ParamName
ParamPrompt
ParamType
ParamLength
ParamScale
Description
DSJobs
ProjectName
JobName
JobCategory
JobShortDesc
JobVersion
JobNLSMapName
TimeDate
Numeric
Currency
CType
Collate
JobDateModified
JobLastUpdated
CenturyBreakYear
CobolProgramName
CompileJCLName
DBMSSystemName
DBMSPassword
DBMSUserName
JobType
NextAliasID
ParameterFileDDName
ParameterFileName
PlatformType
ReservedWordCheck
RunJCLName
TransactionSize
CodeGenLocation
DSLinks
ProjectName
JobName
ContainerName
OutputFromStage
LinkName
InputToStage
LinkType
OutputFileSPName
InpTableFileSPName
EnforceSeqMetaData
UpdateAction
ClearFile
BackupFile
Normalize
TrxRejectRows
TrxRowLimit
PreLoad
ArraySize
LnkIsolation
TransactionSize
TXNBehaviour
Predicate
SQLStatement
TableName
PadChar
CountRecordsAffected
CountTransactions
DatabaseCategory
ConditionalExp
RoutineName
AggregateType
CreateFile
CreateOptions
EnableWriteCache
FTPTargetFileName
DSProjects
ProjectName
CharacterSet
ToolVersion
ServerName
NLSEnabled
PrjLastUpdated
DSTableDefinitions
ProjectName
TableDefnName
TDShortDesc
TDDataSourceName
TDDataSourceType
TDTableOrFileName
SupportsMVFields
NLSMapName
AllowColMapping
TDDateModified
TDLastUpdated
AccessType
ImportLocation
Owner
PlatformType
TDODBCQuoteChar
DSRoutines
ProjectName
RoutineName
RTNCategory
RTNShortDesc
RTNNumArgs
RTNType
RTNVendor
RTNAuthor
RTNVersion
RTNCopyright
RTNDateModified
RTNLastUpdated
RTNJobType
RTNLanguage
RTNLibraryPath
RTNPlatformType
RTNSkipOnNull
RTNExternalName
DSProperties
ProjectName
JobName
ContainerName
StageName
ObjOwnerName
ObjectName
ObjectType
LinkInpOutProp
PropName
LineNumber
PropValue
PropOrder
![Cool 8)](./images/smilies/icon_cool.gif)
DSArgumentMap
ProjectName
JobName
ContainerName
OutputFromStage
LinkName
RtnArgument
ArgumentMap
DSColumns
ProjectName
JobName
ContainerName
OutputFromStage
LinkOrTblDefnName
ColumnName
DataElementName
ColIsKey
ColSqlType
ColLength
ColScale
ColNullable
ColDisplaySize
Association
FieldPos
FieldType
IsGroupOn
AggSortPos
AggSortOrder
ColNLSMapName
ColNull
AllowCRLF
PadChar
PadNulls
DateMask
DependField
LevelNo
NativeType
Occurs
RedefinedField
SignIndicator
SignOption
SyncIndicator
Usage
DSDataElements
ProjectName
DataElementName
DECategory
DEShortDesc
DEBaseType
DESqlType
DEPrecision
DEScale
DENullable
DEDisplaySize
DEDateModified
DELastUpdated
DSJobParameters
ProjectName
JobName
ParamName
ParamPrompt
ParamType
ParamLength
ParamScale
Description
DSJobs
ProjectName
JobName
JobCategory
JobShortDesc
JobVersion
JobNLSMapName
TimeDate
Numeric
Currency
CType
Collate
JobDateModified
JobLastUpdated
CenturyBreakYear
CobolProgramName
CompileJCLName
DBMSSystemName
DBMSPassword
DBMSUserName
JobType
NextAliasID
ParameterFileDDName
ParameterFileName
PlatformType
ReservedWordCheck
RunJCLName
TransactionSize
CodeGenLocation
DSLinks
ProjectName
JobName
ContainerName
OutputFromStage
LinkName
InputToStage
LinkType
OutputFileSPName
InpTableFileSPName
EnforceSeqMetaData
UpdateAction
ClearFile
BackupFile
Normalize
TrxRejectRows
TrxRowLimit
PreLoad
ArraySize
LnkIsolation
TransactionSize
TXNBehaviour
Predicate
SQLStatement
TableName
PadChar
CountRecordsAffected
CountTransactions
DatabaseCategory
ConditionalExp
RoutineName
AggregateType
CreateFile
CreateOptions
EnableWriteCache
FTPTargetFileName
DSProjects
ProjectName
CharacterSet
ToolVersion
ServerName
NLSEnabled
PrjLastUpdated
DSTableDefinitions
ProjectName
TableDefnName
TDShortDesc
TDDataSourceName
TDDataSourceType
TDTableOrFileName
SupportsMVFields
NLSMapName
AllowColMapping
TDDateModified
TDLastUpdated
AccessType
ImportLocation
Owner
PlatformType
TDODBCQuoteChar
DSRoutines
ProjectName
RoutineName
RTNCategory
RTNShortDesc
RTNNumArgs
RTNType
RTNVendor
RTNAuthor
RTNVersion
RTNCopyright
RTNDateModified
RTNLastUpdated
RTNJobType
RTNLanguage
RTNLibraryPath
RTNPlatformType
RTNSkipOnNull
RTNExternalName
DSProperties
ProjectName
JobName
ContainerName
StageName
ObjOwnerName
ObjectName
ObjectType
LinkInpOutProp
PropName
LineNumber
PropValue
PropOrder
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
How, precisely, do you think this will help?
It is not the structure of the Repository, it is the structure of only some of the tables in doc_tool.mdb and presupposes that the poster is using the Reporting Assistant, which has been deprecated since version 6.0. Nor have you show which of the columns are key columns, so the join paths are not obvious even if this approach were to be used - but, then, why would one not be creating custom reports directly within doc_tool.mdb in this case?
It is not the structure of the Repository, it is the structure of only some of the tables in doc_tool.mdb and presupposes that the poster is using the Reporting Assistant, which has been deprecated since version 6.0. Nor have you show which of the columns are key columns, so the join paths are not obvious even if this approach were to be used - but, then, why would one not be creating custom reports directly within doc_tool.mdb in this case?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.