DSXchange

Hi,

I'm using Datastage V8.7, and currently I need to let Datastage job to retrieve records from LDAP. Could any expert give me hints here on how to configure the Datastage so that it be able to query fetch records from LDAP?

Thanks in advance.

One technique that gets mentioned here uses a pair of converts, like so: Convert(Convert('ABCDEFGHIJKLMNOPQRSTUVWXZY0123456789','',YourField),'',YourField) This would remove everything except numbers and upper-case letters. If you have the need, you could add the lower-case alphabet to the mix as w...

Hi Ray,

Thank you for input, I am able to tell me that Datastage does not allow two columns with same name in a table or dataset

And so I am marking the topic close now.

Hi Buddy,

Thanks for telling me it does not allow 2 columns with same name. I wanted it have two columns with same name and same value.

Thanks again man

Hi,

Currently the server version I'm am using is 7.5.1.A to oad data from tables to a data set file using Dataset stage. Is there any way to let the data set file have two exactly same columns(column types,column names .etc) by updating dataset stage?


Thanks

Hi,

Can anybody give a kind explanation on 'Status code = 30107', actually is returned by command like :

Local_JOB_STATUS=`dsjob -run -jobstatus -warn 0 $JOB_PARAMETER -param '$CMDW_LAST_TIMESTAMP'=\'$LAST_UPT_TIME\' $DS_PROJECT_NAME $JOB_NAME`

Thanks,

Try CurrentTimestampMS() and set the extended properties of the column to include micro seconds and set length to 26 and scale to 6. CurrentTimestamp() will give just seconds as you presented if the extended properties are not set. If they are you would get 000000 as the micro seconds. Using Curren...

What operating system? An exact search for "microsecond" should turn up other conversations on this topic, including (from what I recall) the operating systems where this does or does not work. Hi chulett,thanks a lot for reply, OS is AIX 5.1,I seached the forum,but unble to get the answe...

Hi, In project,we need get time-stamp and what we are doing is achieving this via CurrentTimestamp() function in D/S transformer stage but we can only get a value timed to second such as '2004-03-02 16:28:26', and now we wanna one value timed to microsecond such as '2010-08-05 13:29:09.970000',is th...

Thanks chulett.

But could you or anyone know why the data need to "land" before sending to the transformer in this case,so that it can make job run faster.

I saw one datastage question, and it is "The jobs in which data is read directly from OCI stages are running extremely slow. I had to stage the data before sending to the transformer to make the jobs run faster." I'm not clear what's the meaning or action of "stage the data" mark...

nmed27 wrote:Create an entry in uvodbc.config located in your DSHOME.

After finishing this step,please also make one copy of the uvodbc.config locating in your DSHOME under the project folder if you created this project earlier than updating the .odbc.ini/uvodbc.config....

nmed27 wrote:Create an entry in uvodbc.config located in your DSHOME.

After finishing this step,please also make one copy of the uvodbc.config locating in your DSHOME under the project folder if you created this project earlier than updating the .odbc.ini/uvodbc.config....

Hi, I got socked in running one parallel job, and I am pasting the error information below: GenerateColumns,0: Failure during execution of operator logic; GenerateColumns,0: Fatal Error: Invalid Julian day; node_C_LPAR_1A: Player 11 terminated unexpectedly; LeftJoin_OnFMSGroup2,0: Fatal Error: Unabl...

Hi Men,

Thank you both for great help,I have found the definition from D/S manager,and I'd like to close this topic.

Thanks again ^_^