DSXchange

@Kannan,
How are you ?

If your jobs are not big, then you can export the jobs in .dsx format and open them in a notepad and you can search for your string there..

Its the same....

@Craig Its a new line character. Actually this file is getting generated by a Job A and later in Job B this file acts as a source. In Job A, when I view the data of the file(from datastage) its visible. But in Job B, keeping all the properties same as Job A, I am not able to view the data. :cry: I a...

Its not a fixed length file, as specified the delimeter is ^(caret).
Yeah, this test file is having only 1 record.
whats a <lf> ??

does it have a <lf> at the end

It has a new line character at the end. And in the job 2 columns are defined varchar(50) & Smallint respectively.

Hi, I am reading a file through sequential file and I am getting the following error. Internal Error: (endingOffset_ >= startingOffset_+delimLen_): impexp/recordstream.C: 1948 >Traceback: Could not obtain stack trace; check that 'dbx' and 'sed' are installed and on your PATH The properties used in t...

This link may help.

http://publib.boulder.ibm.com/infocente ... 1224n.html

Yeah, we got a mail from our client(IBM) that they have released DataStage 9.1 at IBM Information On Demand 2012 - Global Conference @ Las Vegas 8) Version 9.1 includes a series of advancements that would increase organization's productivity, optimize the integration execution, and accelerate the da...

@Craig,
Whats QED ??

@Ray
I always knew that you were a pedantic

Why? "More than 30,000 Users" remains correct

but more 40k is more precise

The homepagae of dsxchange says MORE THAN 30000 USERS, but there are more than 40k users
When we are going to see
MORE THAN 40000 USERS

If you are very sure that your all the years would be of 21st century i.e. starting with 20 Then you can use a simple formula instead of your 2 step method : if NullToEmpty(InfectCon_Patients.SPECIMEN_DATE) = "" then setnull() else if IsValid("date",InfectCon_Patients.SPECIMEN_DA...

@Craig
I think he's trying to say
Thats ok. take it easy. no comments. work will never stop even if you reply or not

If I were you, I will never do that untill I find out the exact cause for it. Just manipulating your data according to your need is not a correct practice. First you need to find out that why the square boxes were showing up in your data ? Was it due to the file or due to datatype(CHAR) ? E.g If you...

If your source and target have Timestamp datatype then you need not to worry. The database will automatically handle it.
By the way, whats the source datatype ?