DSXchange

I was trying to add a date() function to a parameter in a Job Activity in a Sequencer job. In a job activity, I have a parm called FileName and I am passing a value say File1 and want to append date to that like this... FileName = File1 : date() Did not work. I also try to do oconv but that did not ...

There is no extended properties in ODBC stage Enterprise stage. We workaround the issue by converting date to char in the lookup sql.

I have tried using StringToDate but getting the same error. Actually, the error comes from the Look up ODBC stage. If I remove the lookup altogether, the job successfully loads the data into table but If I use lookup(join stage) I get this error. I use the lookup to check if the record already exist...

I am having problems writing to SQL Server Database(2008) in a DATE column. We have defined DATE data type for a column and we are trying to insert value in the format of 'yyyy-mm-dd'. We get the following error. odbc_lkp: Error when checking operator: When binding output interface field "DATE_...

We have installed NLS in the server to resolve a SQL server datatype of varchar2 which was warranting for NLS installation. After installation, server level NLS was set to MS-1252CS by default and server and parallel maps for projects were set to ISO8859-1. This was causing problems where we used CF...

Hi In serer edition, Before writing to Dimension table, we use a DB2 stage and write the SQL in that to get the next value from the DB2 sequencer.Reason for this is we wanted to generate the SK's before inserting to the table and we pass that also to a file so that we can bypass doing lookup to a di...

I have already demoted it and moved the Local.msh to next environment but was wondering about the reason for the warning. It seems even Ray does not know it so I am ignoring it...

I have a job to do vertical pivot meaning converting rows to columns and the Job design is as follows: DB2 stage----Xfmr-------dedup------Db2 stage I am sorting in DB2 stage itself and in xfmr-input partitioning, I have selected SAME as the partition type which works fine but throws the following wa...

Thanks Craig...I will remember that...Any Idea on the actual Issue ?

Hi I read from a Seq file and do a lookup to database to get the nextval from the DB2 sequencer using DB2UDB/Enterprise Stage and write the output to a Dataset. I have a constant value on both sides of the join to join. EE stage returns the same number for all the records as a nextval. I have tried ...

I have a job in Server which I am converting to Parallel. Please let me know if this is the optimal way to do this. If not please advise me on the best way to do it. Basically, reading from the sequential file and doing looup to a DB2 table two times(based on a condition) and then another DB2 table ...

James - Thanks for the reply. Your reply brought up more questions to me about how stages work internally in DataStage ? IBM training did not help as they taught only the basics and we are new to EE so co-workers can't help.

Where can I get more details about training in dsxhange ?

Thanks for explaining how the sort works. You mentioned in your previous post Joins will not load the tables into memory...Lookups will, although they will do memory mapping against files when possible in most cases Can you please elobarate on memory mapping against files ? If the join stage does no...

Craig - How do I find out If I am running 32 bit/64 bit Datastage ? James - Yes. Everything is on the same mount point. All the 4 fields together may come upto max of 50 chars...I am suspecting number of simultaneous jobs. It's good to know that Join does not store in the memory. So it stores the da...

Craig/James - We are on 64 bit AIX(SMP) and have around 380 GB free space on /datastage/ node and around 8 GB of Memory. Lookup has 4 fields and 17 million records. So it's hard to believe it's out of space or memory. Reason I am worried about using lookup/join in lot of the jobs is that they will t...