Hi
I am new to datastage concepts i want to know about the background process in the server for datastage
How can we change the datatype of column of a datastage job in unix?
Where exactly all datastage jobs stored in the unix server?
To change the datatype of a column of datastage job in unix
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
They are not stored at all in UNIX. They are stored in a database.
Worse (for your purposes), SQL data types are not stored directly as such, but rather are stored as an enumerated value. Unless you know these values, you can not effect a change of data type even with an SQL query against the database. Further, since the data type is one element of a Columns collection, you would need to know how to effect updates in a Collection.
Stick with using the GUI.
There are too many opportunities for you to break your designs otherwise.
Worse (for your purposes), SQL data types are not stored directly as such, but rather are stored as an enumerated value. Unless you know these values, you can not effect a change of data type even with an SQL query against the database. Further, since the data type is one element of a Columns collection, you would need to know how to effect updates in a Collection.
Stick with using the GUI.
There are too many opportunities for you to break your designs otherwise.
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.