Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett , rschirm , roy
nynali
Participant
Posts: 31 Joined: Thu May 03, 2007 11:52 pm
Location: Hyderabad
Post
by nynali » Tue Jul 10, 2007 1:27 am
We have approx. 4000 decimal and char type columns in a Sequential writer. All the columns are Nullable. I need to define the "Null Field Value" for each column thru Edit Column Meta Data. Most of the char columns are more than 20 bytes long. Is there is shortest way to put the spaces rather than pressing space bar equal to the length of the column. I saw in one of the post to put 19 "*" that means replicate 19 times spaces. It is treating like a literal when I used the same expression.
Please help me out on this.
nynali
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue Jul 10, 2007 5:29 am
Enter the 19 spaces then select them. Press Ctrl-C. Then, for all the others, press Ctrl-V. It's a technique called copy-and-paste.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
nynali
Participant
Posts: 31 Joined: Thu May 03, 2007 11:52 pm
Location: Hyderabad
Post
by nynali » Tue Jul 10, 2007 5:35 am
But we have fields which have more than 19 bytes and one of the fields is 350 bytes in length.
ray.wurlod wrote: Enter the 19 spaces then select them. Press Ctrl-C. Then, for all the others, press Ctrl-V. It's a technique called copy-and-paste.
nynali
Hemant_Kulkarni
Premium Member
Posts: 50 Joined: Tue Jan 02, 2007 1:40 am
Post
by Hemant_Kulkarni » Tue Jul 10, 2007 5:43 am
I dont know if this is the right way or not, but this is how we do it
open word document
press space bar, keep track of "Col" in the status bar, press space till Col shows 350 (for field of 350 characters)
Then use the windows' gift ctrl C ctrl V
Maveric
Participant
Posts: 388 Joined: Tue Mar 13, 2007 1:28 am
Post
by Maveric » Tue Jul 10, 2007 5:56 am
nynali is this a parallel job or a server job? U have the same post in server and parallel forum and Job Type in both the forums is parallel.