Date Format in Parallel job

pravin1581 · Post by **pravin1581** » Wed Mar 21, 2007 11:15 pm

Hi All,

There is a date field in the file with data type defined as date and the value as mm/dd/yyyy. The Sequential file stage is unable to read the file.
There is a option of changing the format from default to the one present in the file , the default format is yyyy-mm-dd. Please help me out , how to read the date field in parallel job.

Thanx in advance.

balajisr · Post by **balajisr** » Thu Mar 22, 2007 2:06 am

Did you try changing the format string under date category in format tab of the sequential file to mm/dd/yyyy?

pravin1581 · Post by **pravin1581** » Thu Mar 22, 2007 2:31 am

balajisr wrote:Did you try changing the format string under date category in format tab of the sequential file to mm/dd/yyyy?

Yes the format was changed to mm/dd/yyyy from default , but we are not able to read any data.

gbusson · Post by **gbusson** » Thu Mar 22, 2007 2:36 am

what is the warning message in your log?

balajisr · Post by **balajisr** » Thu Mar 22, 2007 3:01 am

In the Edit column metadata dialog box for the column did you specify any other date format?
Also, post sample data and error which you received.

pravin1581 · Post by **pravin1581** » Thu Mar 22, 2007 4:31 am

gbusson wrote:what is the warning message in your log?

The data in the file is 02/12/2007 and the data type is Date. The filed delimiter is comma . The error that we are getting is :

Parameter specified but not used in flow: DSProjectMapName
##W TOIX 000000 05:28:08(000) <Sequential_File_1,0> Field "Date" delimiter not seen, at offset: 12
##W TOIX 000154 05:28:08(001) <Sequential_File_1,0> Import warning at record 0.
##W TOIX 000018 05:28:08(002) <Sequential_File_1,0> Import unsuccessful at record 0.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 22, 2007 6:37 am

Does your format string include percent signs and delimiters ("%mm/%dd/%yyyy")? Where have you set the format string?

DSguru2B · Post by **DSguru2B** » Thu Mar 22, 2007 9:37 am

Who created this file? Is it some external process or DataStage? And if datastage did, then did a server job create it or a px job?

AaronVG · Post by **AaronVG** » Thu Mar 22, 2007 12:21 pm

I have had a similar delimiter problem when I failed to check my input CSV that I received from a coworker. About halfway through the file, the comma that should have separated the 3rd column from the 4th column (4th being nullable and last column) disappeared.

a,b,c,d <- ok
e,f,g, <- ok
...
w,x,y <- not ok

Nothing was wrong in my code, but the source file was created manually from multiple sources and errors resulted.

Also, it bears repeating, have you changed your format to

ray.wurlod wrote: "%mm/%dd/%yyyy" ?

pravin1581 · Post by **pravin1581** » Thu Mar 22, 2007 10:33 pm

ray.wurlod wrote:Does your format string include percent signs and delimiters ("%mm/%dd/%yyyy")? Where have you set the format string?

The format string includes the percent signs and the format is set in the format properties of the date filed of the sequential stage in the job.

balajisr · Post by **balajisr** » Thu Mar 22, 2007 11:48 pm

Can you post your first 5 rows of your file?

Did you check whether you had assigned any other date format to the column alone?

pravin1581 · Post by **pravin1581** » Fri Mar 23, 2007 12:27 am

balajisr wrote:Can you post your first 5 rows of your file?

Did you check whether you had assigned any other date format to the column alone?

The Date fields are like 02/12/2007, 02/13/2007, 02/13/2007 and henceforth. The column defn has date as the datatype.

balajisr · Post by **balajisr** » Fri Mar 23, 2007 12:35 am

I had asked for complete row and not date column alone.

Also, i had asked date format present in the date column. Right click on the date column and click edit row.

us1aslam1us · Post by **us1aslam1us** » Fri Mar 23, 2007 12:41 am

And also do confirm what is the delimiter used? Is the date format in the field is constant in length? Any null values or spaces in that field ...

pravin1581 · Post by **pravin1581** » Mon Mar 26, 2007 12:39 am

DSguru2B wrote:Who created this file? Is it some external process or DataStage? And if datastage did, then did a server job create it or a px job?

The file has been created with a server job.

DSXchange

Date Format in Parallel job

Date Format in Parallel job

Re: Date Format in Parallel job