DSXchange

srividhya wrote:Hi
Iam also getting the same error,
i tried all the ways -no use
sri

Hi,
can you please be specific what what error you are seeing?

hondaccord94 wrote: inputDate [:timestamp] = StringToTimestamp(string(OpenDate)[%YYYY-%mm-%dd-%hh.%nn.%ss.6](OpenDate))

TRY this

inputDate [:timestamp] = timestamp_from_string[%YYYY-%mm-%dd-%hh.%nn.%ss.6](OpenDate)

Make sure your input string actually has that format!!

If you copying/renaming needs to be done after the job finishes then you can use after-job-subroutine from job properties. On the other-hand if its right after reading from file, while the job is running .. I dont think you can achieve this.. as DataStage expects the input-file/data to be there unti...

I am just curious to know ..what is happening after transformer stage .. i.e, if you pass output of XFM (yyyy-mm-dd) to any other stage .. what you are seeing at the output end ?? is it automatically converting to yyyymmdd or yyyy-mm-dd?

thanks

so does it exclude the duplicate. can you explain me why we get less rows. shivan To answer that question .. one would need the information regarding what exactly are you doing in aggregator. It seems that you have multiple problems .. one being the connection to DB itself which is getting closed t...

did you tried changing (save as or copy) name of the job and compiling?? most of the time that serves the tric for these types of errors

ArndW wrote:Also, is your job compiled and runnable?

yeah!! check for this .. I remember getting error with error_code 99 when the job is not in a runnable state.

thanks for the input.. this morning I got some time and ran couple of tests. 1) varchar field 2) field defaults on format tab set to '' ==> if the filed is defined as NULLABLE then above setting is causing DS to catch null using isNULL ==> if the field is defined as NNN-NULLABLE DS is not recognizin...

Nullable (Null Field Value) = \000 :set the value of a field that contains a null coz even without this i can view data. i thought null is already assigned in the previous statement :roll: regards kumar Hi kumar .. as Lance said #2 makes any error input to be treated as null .. but still it didnt k...

ROY, did you check if DS is detecting that column as NULL? i.e. is IsNull or isNotNull catching that particular field? --------------------- here is my problem/question I am reading pipe delimited input file (eg rec below) with col1-2-3-4-5-6 as varchar 6595960093|||||text Here if I say isNULL(col2)...

Hi Brad, I am following exactly the same approach. Any comments on how it compares with TX stage variable approach for sorted input(determining duplicates by comparing with prev record)?? I have started working on EE very recently and when I ran into this problem, did a search on this forum. But, I ...

Thanks a lot for the info Ray. I am reading from the delimited sequential file and that has decimal numbers. I have the length defined as 5. But as I cant control what I get in input file, if the values is less than 5 digits .. it starts compalining .. what would be the best way to deal with this ca...

No, but i built a hash onthe target and using two links to write to it, one just for update and the other just for insert, it islot better this way now. Thanks, As mdan pointed out, splitting the stream into 3/4 inserts and updates would be fast. In essence thats what you have done by seperating in...

We have recently shifted to EE from server edition. We havent encountered any such problem, so far.

I am interested in knowing what caused this error for you .. could you please share with us .. once you got it resolved..

thanks

Thank you Ray For the decimals also it is looking for x digits, if x is the length specified. Changing definition to Real is working .. but I have just checked the documentation .. it says Real :"IEEE single-precision (32-bit) floating point value" .. so I dont think its a generic solution...