Schema File Structure
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 42
- Joined: Tue Jan 18, 2005 5:48 am
Schema File Structure
Hi,
Can anyone give me a Schema File Templete which is used in the Sequential file Stage .Please give a exaple of what type of file is there.
Is it a csv file or what & where to store that file.
cheers,
Jayant
Can anyone give me a Schema File Templete which is used in the Sequential file Stage .Please give a exaple of what type of file is there.
Is it a csv file or what & where to store that file.
cheers,
Jayant
regards,
Jayant S Thakore
Jayant S Thakore
-
- Participant
- Posts: 16
- Joined: Fri Apr 28, 2006 1:01 pm
hi
Could you please explain how Schema file to be used. I know we can go table defnitions , layout tab , select parallel option. if i copy the schema and pasted into an editor. then How to use this file into datastage ?. If i have several sequential files which want to load to Oracle database. How Schema file helps , how to use. Do i need to give any specific name to the editted file (schema file). Please explain, if possible with an example. Appreicate Ur time.
The name of the file will have an extension of ".rs" meaning Record Schema. This file can be in your folder and can be referred to by the Seq File stage you are using.
There are options to select the schema file name, and its path.
There are options to select the schema file name, and its path.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 16
- Joined: Fri Apr 28, 2006 1:01 pm
Hi
Thanks for the reply, Still I am not getting with your answer. Can you elaborate your answer. When should use schema file, how to use. I have seen few forumns on this, i was not able. With what file name I need to save and import. Can you be breif about this. Thanks again.
Re: Hi
Hey,
Please go through the appendix in the Parallel Job Developer's Guide. Also, see the chapter on Sequential Files.
Please go through the appendix in the Parallel Job Developer's Guide. Also, see the chapter on Sequential Files.
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.
-
- Participant
- Posts: 16
- Joined: Fri Apr 28, 2006 1:01 pm
Re: Hi
I read that, but still i am not clear with my requirement, where I need to load several different format sequential files to Oracle database. Somebody recommended to schema file. Can you let me know how to use this functionality.
In the Sequential file properties tab is an option for a schema file. This defines the fields and other formatting of the sequential file. You might try paramterizing the schema file property of the Sequential file so that you can use different schema files run through the same job. Using a schema file is straight forward although it has many pitfalls. If you are having difficulties understanding its use then I suggest you don't.
-
- Participant
- Posts: 16
- Joined: Fri Apr 28, 2006 1:01 pm
hi
Thanks for the reply, I was able to create using schema file, for testing purpose i used sequential file as source and target. when I am loading emp data to the target sequential file using schema file,I am getting following errors, i tried to null value , can you help on this error.
Sequential_File_1: When checking operator: When validating export schema: At field "HIREDATE": "null_field" length (1) must match field's fixed width (19)
Sequential_File_1: When checking operator: When validating export schema: At field "SAL": "null_field" length (1) must match field's fixed width (9)
Sequential_File_1: When checking operator: When validating export schema: At field "HIREDATE": "null_field" length (1) must match field's fixed width (19)
Sequential_File_1: When checking operator: When validating export schema: At field "SAL": "null_field" length (1) must match field's fixed width (9)
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This is nothing to do with the use of a schema file or otherwise. What it has to do with is the value you have given to the "Null Field Length" property. When you specify fixed-width format, then the "Null Field Length" (or the "Null Field Value" if you use that) must exactly correspond to the declared width of the nullable field in question.
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.
-
- Participant
- Posts: 16
- Joined: Fri Apr 28, 2006 1:01 pm