In few cases I have faced problems with Transformer compliation,
That case was, when I tried to handle the null for a stage variable.
I tried like If Isnull(STAGEVAR1) then ' ' Else Trim(STAGEVAR1).
Check out, If you have any cases like these.
Search found 218 matches
- Wed Dec 06, 2006 5:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Wierd Transformer Compiler Error
- Replies: 5
- Views: 3094
- Wed Dec 06, 2006 4:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Order By Clause or Explicit Sort Stage
- Replies: 18
- Views: 8913
One can reduce the overhead of including additional stages when the same functionality is provided by the previous stage (ORDER BY clause in this case).[/quote] Here overhead of one sort stage is not a problem. The tsort operators from Datastage will overhead to your job. The tsort operators will de...
- Wed Dec 06, 2006 4:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Script to assign default value to an ENVIRONMENT Variable?
- Replies: 1
- Views: 878
Re: Script to assign default value to an ENVIRONMENT Variabl
Hi, Can we write a script to assign default value to Datastage ENVIRONMENT variables? If yes, then is it a good practice or not ? Bandish Normally, Datastage ENVIRONMENT variables are used to Override the default values at project level or at job level. Usually these values are True or False and so...
- Wed Dec 06, 2006 3:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to handle the join stage warnings
- Replies: 15
- Views: 6065
Hi, Warning Messages- We have to analyse those warnings properly and by max, we have to find the cause and solution for the same. Message Handlers are helpful, whenever your warning is not harming your job and if your unable to find a solution for your warning. Warning like Prior Component with same...
- Tue Dec 05, 2006 9:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Number of Source files in DataStage PX
- Replies: 2
- Views: 1446
Hi, More Info about ulimit : /usr/bin/ulimit The ulimit utility sets or reports the file-size writing limit imposed on files written by the shell and its child processes (files of any size may be read). Only a process with appropriate privileges can increase the limit. Fire the following command in ...
- Tue Dec 05, 2006 9:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to handle restarting of subsequnces in Failure cases
- Replies: 18
- Views: 7893
Hi, As per your requirement, It is must to abort your main sequence and then only you have a option of Restart of Main and Subsequence after failure. It will not make any problem, even though your main sequence shows aborted. More ver, it is giving you a option of restarting of your failed sub seque...
- Tue Dec 05, 2006 5:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: HowTo connect to DB2 using DB2_UDB_Enterprice?
- Replies: 7
- Views: 8390
Yes. I type password in parameter. And I sure that password is correct. Sorry... haw I can hardcore the values? Try to Hardcore the value means, instead of paasing the value as parameter inside the DB2 EE stage, use the Hardocre value. For Ex : If you are passing password as '#DB2_PASSWORD#' in pla...
- Tue Dec 05, 2006 5:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to handle restarting of subsequnces in Failure cases
- Replies: 18
- Views: 7893
- Tue Dec 05, 2006 4:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: file name
- Replies: 9
- Views: 3334
Re: file name
Hi,m903782 wrote:is there any way to reach the name of the file when you work on it in datastage
First clarify your requirement. Other wise, here so many assumptions are going on.
You mean you want to pass the file name as parameter ? ( One more assumption )
- Tue Dec 05, 2006 3:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to handle restarting of subsequnces in Failure cases
- Replies: 18
- Views: 7893
- Mon Dec 04, 2006 12:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Override Fully Qualified Table Name
- Replies: 8
- Views: 2870
- Mon Dec 04, 2006 11:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sql server
- Replies: 6
- Views: 2313
- Mon Dec 04, 2006 5:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: error "Null value on accessor interfacing to field"
- Replies: 4
- Views: 3965
- Mon Dec 04, 2006 3:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Socket closed error, when parallel jobs run in sequence
- Replies: 4
- Views: 3956
Hi, I think, these are all because of resource allocation to the jobs for monitoring the data. We have environmental variables called APT_MONITOR_SIZE and APT_MONITOR_TIME. These variables will lead the monitoring functionality in Data Stage. overridden the default setting with values, set APT_MONIT...
- Mon Dec 04, 2006 3:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: warnings when changing the data type
- Replies: 6
- Views: 2199
Hi Praveen, In which stage you are performing this converison either Transformer or Modify stage. Use the Proper syntax for that in the above stages. If you are perfoming this in any satge without any conversion, then it will throw error to you. In Tarnsformer : TimestampToString Return the string r...