DSXchange

Hi All,
We have imported all the jobs from 6.x to 7.5.
but only few of the jobs can be seen instead of all.
Already searched this fourm.
Need your suggetions.
Thanks
Prashant

Hi Kenneth,
I shall go with 1st option, Atleast i can have tea .
Thanks you for your suggetion.
Prashant

I have very big dsx file around 400 MB of whole project.
Out of this , I want to import only rountines.
Need ur suggestion.
Thanks
Prashant

For convert function

Expression should be Convert("\r", " ", MyString)

For replace function

Expression should be Ereplace(MyString, "\r", " ")

thanks

Also giving a search with string "Routine" on the forum will give you idea

about how to effectively use Basic with respect to real time senario.....

thanks

Prashat

ArndW wrote:(a) Access rights to target directory
(b) disk space available

if so then how come this job is successfully creating several other files in

the same directory and giving error only for this file.

I guess in that it should be same for all the files.

Thanks

HI all,

while running the jab coming across below error

main_program: Fatal Error: Could not create output file ascl/dsadm/Ascential/DataStage/Projects/LETS_PA/tar/WeekdayFromDate.ds.
filesystem related error

Checked every thing is intact.

How to resolve?

Thanks

Along with you can give search for "routine" on the forum to have idea

what can you do with routine & how to utilise it and many more things to

get your objective achived.

Thanks

Prashant

Hi All, I ran a job and got the phantom error mentioning DataStage Job 2288 Phantom 16902 Program "JOB.969034386.DT.1369240453.TRANS1": Line 71, Nonnumeric data when numeric required. Zero used. . . . . . <repeating as many times as rows in the source table> in order to resolve this i went...

I got this error one time. Maybe this particular column job_lvl datatype in the DataStage is different from what is in the Table is the Database. For. Eg In the Datastage I had a Prod_id Char(5) and in the Oracle Table it was only Char(4). I had changed it to char(5) manually in the DS thinking I h...

Arndw,

That's true it will work only for JAN & AUG.
Seeing the sample data provided , i presumed so.

Thanks
Prashant

Again, I feel it can be done as string manipulation with out using date conversion like this, if Field(Instring,1," ")=JAN then In.InString[4,4]:'01':In.InString[1,2] else In.InString[4,4]:'07':In.InString[1,2] Hope not going against ArndW :) Correct me if i am wrong? Thanks Prashant

Thanks for responses, My Ans to Q asked : Q: Is this happening to the last column? Are there any transformation being performed on the column involved? Ans: No this Happening at first column of Target Sequientail file however the source column from where it is coming is last one. Following transform...

Hi All,

When I am passing the data from one sequential file to another thro' transformer ,this character  is getting appended to one of colum.

I am wondering why?

thanks

srinath,

But we wont get Null in the Target If we apply the some handle_null tranfermations/derivatives .

As we want Null in the target with no warnings at all.

Thanks

Prashant