Search found 30 matches
- Sat Jul 14, 2007 9:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null values in sequential file
- Replies: 4
- Views: 2222
- Tue Jul 10, 2007 6:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null values in sequential file
- Replies: 4
- Views: 2222
Null values in sequential file
Hi, I have sequential file as output and the all the columns (about 4000) are nullable = YES type columns. Now my questions are >> will the seq file can store null values as is? >>If I want to specify blanks/spaces (for both char and decimal columns) in case the coming value is NULL for that field,h...
- Tue Jul 10, 2007 5:35 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Null default value
- Replies: 4
- Views: 1695
- Tue Jul 10, 2007 2:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null default value
- Replies: 1
- Views: 741
Null default value
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 rath...
- Tue Jul 10, 2007 1:27 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Null default value
- Replies: 4
- Views: 1695
Null default value
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 rath...
- Mon Jul 02, 2007 3:01 am
- Forum: General
- Topic: Can we set the default to null!!
- Replies: 3
- Views: 1809
Can we set the default to null!!
Hi,
I am having some decimal columns in my Source sequential file.
Whenever I get junk data for these(which is not decimal) I want to default them to NULLS.Please let us know if this can be done??
I am having some decimal columns in my Source sequential file.
Whenever I get junk data for these(which is not decimal) I want to default them to NULLS.Please let us know if this can be done??
- Thu Jun 28, 2007 6:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ORCHESTRATE step execution terminating due to SIGINT
- Replies: 1
- Views: 1462
ORCHESTRATE step execution terminating due to SIGINT
Please help me with this error.
ORCHESTRATE step execution terminating due to SIGINT
ORCHESTRATE step execution terminating due to SIGINT
- Thu Jun 28, 2007 1:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Compile error in transformer
- Replies: 11
- Views: 4840
Hmm.. Thanks ArndW..I will take that suggestion.Will look into that and let you know if anything fruitful comes out. nynali - what platform are you on and which compiler are you using? Once you get that information find the relevant manual or web page and see if the compiler will allow that 32Kb val...
- Thu Jun 28, 2007 12:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Compile error in transformer
- Replies: 11
- Views: 4840
I was able to compile the job by splitting into 1000 columns each but when I try with 1500 or so it again fails.So I shortened my Column Names and the job went fine. So is there any method to increase the 32765 limit?? Well, lets try to confirm, that really is the issue here. Split the columns into ...
- Tue Jun 26, 2007 9:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Compile error in transformer
- Replies: 11
- Views: 4840
- Tue Jun 26, 2007 9:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Compile error in transformer
- Replies: 11
- Views: 4840
I have around 3800 columns as input to the transformer.So please let me know if this is causing a problem and if it is the case please let me know how to handle this?? It could be a missing quote character - 32KB is a heck of a long string literal - maybe the compiler is still searching for the clos...
- Thu Jun 21, 2007 9:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Warning in the transformer stage while running the job
- Replies: 2
- Views: 1443
Warning in the transformer stage while running the job
Please help me with this warning.What settings need to be changed in the transformer.
"Input dataset 0 has a partitioning method other than entire specified;
disabling memory sharing."
"Input dataset 0 has a partitioning method other than entire specified;
disabling memory sharing."
- Wed Jun 20, 2007 11:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Compile error in transformer
- Replies: 11
- Views: 4840
- Wed Jun 20, 2007 9:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Compile error in transformer
- Replies: 11
- Views: 4840
Compile error in transformer
"/data/ds/cl/int/projectlibs/dpr_cl_int/RT_BP1217.O/V97S5_djpCladdIntglogscope_nosplit_Scp_ind_stage.C", line 3258.36: 1540-0872 (S) A string literal cannot be longer than 32765 characters.
Please help me with the above compilation error.
Please help me with the above compilation error.
- Tue Jun 19, 2007 12:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem with Inner Join
- Replies: 1
- Views: 1074
Problem with Inner Join
Hi, I am joining two datasets thro an inner join. These two datasets are previously sorted and partitioned on 3 keys in another job. In the INNER JOIN job I am doing some transformations to one of the dataset and then doing an inner join. I am now doing a join on 5 keys and the three keys(mentioned)...