DSXchange

I cant use business rule stage, coz all my transformation is done in transformer stage , I just want a way to keep track of the number of invalid i/ps if I use business stage I would lose that information or else I have to move all transofrmations into business rule stage. Neway Thanks once again. S...

Thanks Mike, but my situation is different anyway I guess I have 2 go with creating an additional job option.

IF COND=1 THEN VAR+1 ELSE IF COND=2 THEN VAR+2 END I understand that if first if condition turns out to be true it doesnt check for the second condition. What if I want to check for all the conditons. I mean instead of if then else. I want if then end, if then end. Can I have more than two if stmts...

* is a comment line. Also BASIC if then else is different than one used in a transformation. In a transformation it is treated as a single line statement therefore there is no end like a multiple line if then else. if x = 1 then 10 else 20 This will assign a 10 or 20 to column in a transform. Yeh t...

It's end else if <condition> then <expression1> <expression2> end else <expression3> <expression4> end [/quote][/quote] But I dont want to return any thing from <expression2> I mean based on that condition I want to increment the counter variable. e.g., if var1=0 then var2 count:=count+1 end will th...

Hi,
I have this question regding if then -else.
Can we acheive
if <condition>
then <expression1> <expression2>
else
<expression3><expression4>
end

i.e., performing multiple actions based on single condition checking.

Let me know if I am not clear.
Thanks
srikie

Hi,
I would like to know if it is possible to get parameters from two different files. As, we could only specify one file name in job properties-parameters.
I am using Data Stage mvs 7.5
Thanks
srikie

Thanks everyone.I think I nailed the problem down. I dint validat ethe date before casting onto timestamp. Now its workin fine.
Thanks once again

Thanks Mike I would try that out.Yes, I tried Data stage timestamp internal format it dint work either.

Code generation is fine but when you try to execute the jcl it gives the error of invalid casting. If you see the documentation of data type definitions and mappings, mapping date to timestamp and vice versa is invalid.
Thanks
srikie

Mike wrote:That's the DB2 format for a timestamp. Look at the CAST function documentation in your mainframe job developer's guide.

Mike

Yeah we are actually loading to db2load ready flat file.

srikie, I don't have access to a mainframe to try some options, but this is what I would assume would be the way that CAST AS TIMESTAMP would work: 1) If character, I would expect that you would have to provide a 26-character string in standard DataStage timestamp format. 2) If date, I would expect...

DataStage standard timestamp format is "CCYY-MM-DD HH:MM:SS.NNNNNN". I assume the time delimiters probably matter. Mike No, when I get the current timestamp its displaying the timestamp in 'CCYY-MM-DD-HH.MM.SS.NNNNNN' format not in "CCYY-MM-DD HH:MM:SS.NNNNNN" , thats why I chos...

It still is giving the same zeros.
I dont know where look for? I mean atleast it should give the date if not the time.

Mike wrote:srike,

I think Sainath.Srinivasan has probably nailed your problem. The CAST function expects a DataStage format timestamp (i.e. without the dash between the date and time portions).

Mike

But the delimiters could be anythg right? I mean 'hh.mm.ss.ssssss' or should it only be 'hh:mm:ss.sssssss'