DSXchange

lak4u

A "fixed width file" means each record is exactly the same number of characters long and each field is always the same size, even when "empty". Use "char" fields and make sure you populate them appropriately - as in all spaces for the ones with no data. Thanks for repl...

lak4u

My source file is delimited file and I need to poupulate fixed width file
but when I created the file, the empty field has #####. I tried to trim and tried to remove ###, still I couldn't, please help.

Thanks

lak4u

Hi,

How to convert datastage datetime in SQL server datetime formate('1/1/2010 12:00:00 AM')

Thanks

lak4u

Hi,

I am try to read this record from text file with different NLS settings but getting this error

error-----"nls_read_fixedwidth() - row 1, too many columns in record"

record------ бурение куст 35 скв 269Б Ноябрь

Please help

Thanks

lak4u

chulett wrote:From the Administrator's command window or at a TCL prompt, making sure you are connected to the proper project. Use LOGTO if you are unsure.
Code: Select all
cd $DSHOME
. ./dsenv 
./bin/dssh
LOGTO <You ...[/quote]

Thank you Chulett.Now I am able to do it from DS Admin Commend

lak4u

Thanks for info.Where do I execute this? Kim Duke has posted this query very long back SELECT DS_JOBS.NAME AS JOB_NAME, DS_JOBS.CATEGORY, DS_JOBOBJECTS.NAME AS OBJECT_NAME, DS_JOBOBJECTS.OLETYPE, EVAL DS_JOBOBJECTS."if index(upcase(@RECORD),'YOUR SEARCH STRING',1) > 0 then 'FOUND' else ''"...

lak4u

chulett wrote:Export it and then search the .dsx file.

Thank you Chulett

lak4u

Hi,

any way to search a DataStage project to find all the jobs where a project variable is being used?

lak4u

Hi,

I have Abnormal termination of stage job.transformer detected error when I reset I got ..

From previous run
DataStage Job 90 Phantom 5532
Unhandled exception raised at address 0x7C82CAA2 : Access violation
Attempted to read from address 0x00000000

Aborting DataStage...

Any help please...

lak4u

Hi

I am getting these warning s,I amwrting into text file and reading from text file,since I have rassian chars i am using NLS setting "KOI8-R"

"nls_read_fixedwidth() - row 1027, too many columns in record"

help please

Thanks

lak4u

chulett wrote:That line number is from the SEQOpen routine, not the transformer. Are you reading from or writing to this file? Is it repeatable or a 'random' error? ...

Its writing into text file.Its a 'Random error' but I swa this error couple time before also.

Thanks

lak4u

Hi I am getting folowing error and I checked in RT_BP90 also but I don't see any 553 line in that file JOB.486106680.DT.1514650636.TRANS1 ,I know they are few threads on this topic but I couldn't find solution anybody can please help DataStage Job 90 Phantom 5288 Program "DSD.SEQOpen": Lin...

lak4u

Not sure what you mean. If you can send email from the Notification Activity stage, you can email a phone. You'd need to provide details of exactly what you're doing if you need help. ... I have give below details in Notification stage it sending to my email id but not to cell phone... but same ema...

lak4u

Send short emails to your cell phone. All carriers will have an "email address" for your phone. For example: http://www.tech-recipes.com/rx/939/sms_email_cingular_nextel_sprint_tmobile_verizon_virgin/ Thanks Chlett, Itried this from our out look but its not getting from DataStage Notifica...

lak4u

Hi,

Is there any way that we can send SMS(Text messages) to Cell phone thru DataStage.I know we can send emails.Please help

Thanks

DSXchange

Search found 42 matches

Delimiter format for Fixed width

SQL server Datetime

nls_read_fixedwidth

search variable

Abnormal termination of stage job.transformer detected

nls_read_fixedwidth()

Exception raised in GCI subroutine

SMS notifications to Mobile